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

From Foochal

Jump to: navigation, search


[edit]

Cannot drop user in Oracle (ORA-01940 cannot drop a user that is currently connected) 

ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
[edit]

Solution

Connect all clients connected to Oracle with this user name. You may have a sqlplus client connect in another window with the user that you are trying to delete.

You can also kill any existing session using the web admin tool that comes with Oracle 10g.

  • Goto admin interface: http://localhost:8888/apex/ as "admin" (default password for admin is adminadmin)
  • Goto Administration -> Monitor -> Sessions
  • Select a session by the user you are trying to drop
  • Press "Kill Session"
Retrieved from "http://wiki.foochal.org/index.php/ORA-01940:_cannot_drop_a_user_that_is_currently_connected"

Personal tools