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: exp/imp utilities index space

Re: exp/imp utilities index space

From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Fri, 08 Aug 2003 22:03:14 +0000
Message-ID: <3219489.1060380194@dbforums.com>

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.com
Received on Fri Aug 08 2003 - 17:03:14 CDT

Original text of this message

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