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: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 11 Jun 1999 09:58:17 -0700
Message-ID: <37614029.3C2C4C8E@us.oracle.com>


Because it's an import parameter, not an export one.

HTH. Pete

"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.

--

Regards

Pete


Received on Fri Jun 11 1999 - 11:58:17 CDT

Original text of this message

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