Got a ORA-01940 and the user is not connected. Why?
85870Apr 1 2005 — edited Oct 11 2006Hello.
I am trying to drop an user but Oracle raise an ORA-01940 error, but the user is not connected.
Please, can anyone tell me why can this be possible?
Thanks in advance.
SQL*Plus: Release 9.2.0.1.0 - Production on Vie Abr 1 10:59:56 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Conectado a:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> DROP USER MYUSER CASCADE;
DROP USER MYUSER CASCADE
*
ERROR en lÃnea 1:
ORA-01940: cannot drop a user that is currently connected
SQL> SELECT COUNT(*) FROM V$SESSION WHERE USERNAME='MYUSER'
COUNT(*)
----------
0