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 Tablespace - Taking long time.

M.M.RNov 14 2010 — edited Nov 14 2010

Hi Team,

I am trying to drop the tablespace its taking too much time .. around half an hour..!!

We have allocated that tablespace to the perticular user I am tring to kill the sessions for that user nut sessions are marking for kill but not releasing ..Please help..!

TS is having only one datafile which is 500 MB

DB version 10g RAC

Thanks Mano.

This post has been answered by sb92075 on Nov 14 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2010

Added on Nov 14 2010

#general-database-discussions

20 comments

6,023 views