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!

How do I close all connections to a schema ??

ice_cold_aswinNov 12 2007 — edited Nov 12 2007
Hello there,

I got to drop the existing user. When I tried to DROP USER <user name> CASCADE, it displayed a message that read cannot drop a user with existing connections.

I have killed all sessions that are open to this schema.. Still I am facing this problem?
How do I know those connections and how do I close them ???
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2007
Added on Nov 12 2007
9 comments
725 views