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!

taking a long time to drop a user?

550825Oct 11 2007 — edited Oct 11 2007

I have code that sets up user accounts and creates a set of tables. when those accounts need to be recreated, I have code that drops the accounts.

There are no sessions connected as the user. I go

drop user <username> cascade;

and it takes a long time to drop the account. how do you diagnose why it takes so long for ddl to run?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2007

Added on Oct 11 2007

#general-database-discussions

8 comments

1,707 views