Dropping tablespace (zero-block tablespace)

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 Sun Aug 16 1998 - 17:56:23 CDT