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 user take too time

User_T0YOGAug 27 2014 — edited Aug 27 2014

Dear All

I have a oracle 11g 2.04 user with 100,000 tables but almost tables are empty and Dump file size is 3 Gb . I'm trying to drop this user by using cascade option but it is taking too long...it's more than 11 hour .

Is there any way to improve that to be faster ?

Regards

Odai

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2014

Added on Aug 27 2014

#general-database-discussions

7 comments

3,011 views