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 Command taking considerable time!!!

629537Jul 29 2008 — edited Jul 29 2008

Hi guys,

In the morning i had asked u alll about Truncate command taking time.

I used "Truncate <table> reuse storage" for truncating the table. It worked fine.

Now, when i'am dropping that same table due to some change in our plan, this is also taking considerable amount of time...

FYI,
The tablespace is Dictionary Managed Tablespace and the Oracle Version for this is 9.2.0.8.

Can somebody help...

Regards,
Nick.

Message was edited by:
Nick-- wud b DBA

Message was edited by:
Nick-- wud b DBA

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2008

Added on Jul 29 2008

#general-database-discussions

13 comments

930 views