Home » SQL & PL/SQL » SQL & PL/SQL » drop user username cascade just hangs..
drop user username cascade just hangs.. [message #19157] Sun, 03 March 2002 23:17 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
I have issued drop user username cascade;
It hangs for a long time and there is no response at all.
What may be the problem with the database.
There are no people working on this database and they are no database operations going on.
I have shutdown the database and restarted it.It went fine.
After that,i have again issued drop user username cascade.
Still it hangs.I have waited for nearly an hour,but still it does not drop the user.
Any help is appreciated..
Re: drop user username cascade just hangs.. [message #19168 is a reply to message #19157] Mon, 04 March 2002 03:29 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
use "select username from v$session" and makesure user is not connected.
Previous Topic: Pleaseeeeeeeeeee help me, its quite urgent
Next Topic: SQL command
Goto Forum:
  


Current Time: Thu Mar 28 15:13:34 CDT 2024