Re: Dropping tablespace (create zero-block tablespace)

You can create a tablespace that is 1K in size, that way there is no way any objects can be created in that tablespace. (It's not really a 0 block tablespace, it's just needs to be less than the block size of your database)

This should do the trick.

Gerri L. Papillon
Oracle DBA
PTCS Corp.

In article <1998081702331800.WAA15268_at_ladder01.news.aol.com>,   levinir_at_aol.com (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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 25 1998 - 13:16:45 CDT