Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: importing into a different tablespace

Re: importing into a different tablespace

From: Gennaro Napolitano <Gennaro.Napolitano_at_italdata.it>
Date: Fri, 11 Jun 1999 16:37:27 +0200
Message-ID: <37611F27.A55E8197@italdata.it>

"Alex Andr." wrote:

> Hi!
>
> Marc Mazerolle wrote:
>
> > If you only have a few tables :
> >
> > Pre-create the tables you want to move in the new tablespace and then
> > import with "tables=(...,...) ignore=yes". The import will try to create
> > the tables and, since they will already exists, will import the data into
> > the existing one.
> >
> > To pre-create the tables, use import with "show=y logfile=precreate.sql".
>
> I'm use Oracle 8i export and it say that show - invalid parameter. Why?
> Tanks. Alex.

Use "log=precreate.sql"

Ciao Gennaro Received on Fri Jun 11 1999 - 09:37:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US