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!

Drop Temp tablespace hangs...

The_RockJun 16 2010 — edited Jun 16 2010

I have created a new TEMP tablespace and made it default TEMP one.

Now I want to drop TEMP3 tablespace, because it has become fulll...
when I drop it through EM, it hangs...
- - - - - - - - - - - - -- - - - - - - - -- - - - -- - - - - - -- - - - - -- - - -

Once a tablespace has been dropped, the objects and data in it will no longer be available. To recover them can be a time consuming process. Oracle recommends a backup before and after dropping a tablespace.

Are you sure you want to delete Tablespace TEMP3?

Delete associated datafiles from the OS
--------------------------------------------
When I checked at EM, there are locks too..

SMON has locked the system
----------------------
What should I do now?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2010

Added on Jun 16 2010

#general-database-discussions

17 comments

12,179 views