Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

When can I safely drop a temporary tablespace?

krisscoMar 22 2010 — edited Mar 22 2010

I have a temporary tablespace in my database that I would like to get ride of.
It was created with a statement similar to this:

CREATE TEMPORARY TABLESPACE "TEMP"
blah blah blah. . .

I have checked dba_users and dba_extents. It is not used in either places.

Is there anywhere else I should check prior to executing a "DROP TABLESPACE" command?

Thank you,

-Kris

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2010

Added on Mar 22 2010

#general-database-discussions

7 comments

1,230 views