ORA-01940: Unable to delete the currently connected user

ORA-01940: Unable to delete the currently connected user & ldquo; ORA-01940: Unable to delete the currently connected user & rdquo; error resolution When deleting a user reports ORA-01940: failed to delete the currently connected user & quot; error solution: 1. Search for session username, sid, serial # fromv $ session --- USERNAME & nbsp ;&

ORA-01940: Unable to delete the currently connected user

ORA-01940: Unable to delete the currently connected user error resolution when you delete a user, an ORA-01940: Unable to delete the currently connected user error is reported

Solution:

1. Search for sessions

Username, sid, serial # from v $ session

--- Username sid serial #

--- MYNAME 9 476

2. Force close session

Alter system kill session '123'

3. delete the file.

Drop user MYNAME cascade

SQL> drop user a cascade;
Drop user a cascade
*
ERROR is located in row 1st:
ORA-01940: Unable to delete the currently connected user

Solution:

SQL> select username, sid, serial # from v $ session;

Username sid serial #
--------------------------------------------------
1 1
2 1
3 1
4 1
5 1
6 1
7 1
SYS 8 3
A 9 4

Nine rows have been selected.

SQL> alter system kill session '9, 4 ';

The system has been changed.

SQL> drop user a cascade; // Delete the user and all objects in the user tablespace

User discarded