Skip to Main Content

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!

user is not droping

902332Nov 29 2012 — edited Nov 30 2012
hi,

db is 10.2.0.4.0

trying to delete user:
drop user <user_name> cascade;
but saying user is currently connected,

when i checked there is not sid, serial# from v$session.

in the last seesion i treid to drop, but there it was hung.

can you please help me on this. it's urgent pls.

thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2012
Added on Nov 29 2012
17 comments
318 views