Re: Dropping tablespace (create zero-block tablespace)

The tric here is a bit more simple than described below

• Make sure the tablespace you want the tables to go to does exist and is the users default tablespace
• Make sure the 'old' tablespace doesn't exist
• The create table commands issued by import will now fall back on the default tablespaces as long as you don't forget to specify ignore=Y on the command line or ignore errors in the import dialog *

Hth

Sybrand Bakker

LEVINIR wrote:

> I am working on project where in one instance default tablespace for users
> objects is user_data and in second default tablespace is users . I have to do
> full export of first instance, then drop this instance, and do full import to
> second instance (second instance is empty).
>
> When I import I have to make sure that users objects who's default tablespace
> was user_data would be imported into second instance and go to tablespace
> users. Also user_data tablespace should not be created in second instance. Do
> you have any suggestions? Import from user to user works just fine, but I have
> to do full import.
>
> I though this paragraph that I got from Oracle7 Server Utilities User's Guide
> would be helpful in my case, however I don't understand how to create zero
> block tablespace.
>
> Dropping a Tablespace
> You can drop a tablespace by doing a full database export, then creating a
> zero-block tablespace with the same name (before logging off) as the tablespace
> you want to drop. During import, the relevant CREATE TABLESPACE command will
> fail and prevent the creation of the unwanted tablespace. All objects from that
> tablespace will be imported into their owner's default tablespace.
>
> I would really appreacite your help.
> Thanks
> Irina
Received on Mon Aug 17 1998 - 12:52:06 CDT