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: Alex Andr. <deep_at_uqcd.poltava.ua>
Date: Fri, 11 Jun 1999 16:41:01 +0300
Message-ID: <376111ED.11083999@uqcd.poltava.ua> 





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.


Received on Fri Jun 11 1999 - 08:41:01 CDT












Original text of this message













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