Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp/imp utilities index space
Import (imp) will import the tables and indexes into the default tablespace for the user you are importing into if the tablespaces from export do not exist.
To avoid this, you create the tables/indexes in the correct tablespaces and then import with IGNORE=Y option.
-- Posted via http://dbforums.comReceived on Fri Aug 08 2003 - 17:03:14 CDT