How do I close all connections to a schema ??
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 ???