Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01940: cannot drop a user that is currently connected
ORA-01940: cannot drop a user that is currently connected [message #245836] |
Tue, 19 June 2007 00:05  |
soujanya_srk
Messages: 111 Registered: November 2006 Location: HYDERABAD
|
Senior Member |
|
|
i am trying to drop a user, am getting this error
and i am not connected to this user
ORA-01940: cannot drop a user that is currently connected
i did
select username, machine, status from v$session;
and for my machine, it displays active, making this inactive
is the solution for dropping the user?
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 25 00:19:00 CDT 2025
|