Skip to Main Content
Forums

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 temporal tablespace

dbajugJul 4 2011 — edited Jul 4 2011
Hi all,

I'm working with an 11.2.0.1 RAC. I need resize the temp tablespace. In order to do it, I've created a new temp tablespace with the correct size and I've configure it as default tablespace for database. After it, I try to drop the old temp tablespace but when I launch the drop sentence, it never finish.

I've take a look and I can see some inactive sessions are using the old temp tablespace.

How can I drop it? Any ideas?

Best Regards,
dbajug
This post has been answered by Rodriguez on Jul 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2011
Added on Jul 4 2011
#general-database-discussions
11 comments
300 views