SQL Error: ORA-01940: cannot drop a user that is currently connected
01940. 00000 - "cannot drop a user that is currently connected"
*Cause: Attempt was made to drop a user that is currently logged in.
*Action: Make sure user is logged off, then repeat command.
When you planned to drop user in oracle. sometime you will get error like this
Kill session in Oracle |
Solution:
Login with sys user of your database, and enter this query.
select sid,serial# from v$session where username ='BAW'
It will display you the list of sid and serial#, which your user is using.
Then use this query
Alter system kill session '143','500';
were 143 is sid and 500 is serial#
once you kill all the session related to this schema, drop this user now.
Now you have successfully dropped your schema.
Comments
Post a Comment