ORA-01940: cannot drop a user that is currently connected

JavaScript: How do you draw beautiful terms?>>

Issued by:

SQL}}DROP USER USER1 CASCADE

ERROR: ORA-01940: cannot drop a user that is currently connected

from the user currently connected to data libraries, so it cannot be 21024;

Found:

1, search for the user’s session process,

SQL] (SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME=’USER1′;

SID SERIAL#
——————
24 25341

2, end all sessions of the user

SQL ALTER SYSTEM KILL SESSION ‘24,25341’;

System altered.

3, subsequently 21024;, user

SQL] (DROP USER USER1 CASCADE);

Similar Posts: