Re: ignoring one tablespace on full import

You have to pre-create USER_NAME and assign that USER to DEFAULT TABLESPACE,
The IMPORT will use DEFAULT TABLESPACE of the USER it's IMPORTING TO.

So in your case you need to find out who was the owner(s) of the objects in the "IGNORING_TABLESPACE"
pre-create that or those users on your new DB and assign them to DEFAULT TABLESPACE named something
like BLOW_ME_AWAY. After the import completes do this: SQL> DROP tablespace BLOW_ME_AWAY including contents;

You are done !

Vitaliy Mogilevskiy

Doug Cowles wrote:

> Is there any way to do a full import and prevent one
> tablespace from loading? We tried just making sure
> the tablespace didn't exist, but it ended up dumping
> all the data into SYSTEM tablespace, cause a rebuild
> of the database. Chaging the quota won't work, since
> the import is done as sys.
>
> - Dc.
Received on Tue Mar 23 1999 - 16:58:03 CST