| drop user cascade hangs [message #110672] |
Wed, 09 March 2005 10:21  |
Arpit
Messages: 99
Registered: March 2001
|
Member |
|
|
Hi,
I need to drop a user (schema) and have initiated a
SQL> drop user <username> cascade;
since couple of hours and it's still continuing to run (hanging) with no error messages (either in the alert or udump)?
I've confirmed that there is no session connected to this user and have also bounced the db followed by server restart but doesn't help.
I have stopped the archiving temporarily as i need to run an fromuser touser import after the user is dropped sucessfully and recreated.
PLEASE HELP ASAP!
Thanks,
|
|
|
|
|
|
| Re: drop user cascade hangs [message #110758 is a reply to message #110672] |
Thu, 10 March 2005 01:13  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| Quote: |
since couple of hours and it's still continuing to run (hanging)
|
There is a major difference between 'continuing to run' and 'hanging'. In my experience, it is very very rare that sessions 'hang' (doing nothing at all), mostly they do a lot of work that you don't know about.
Use your dba-tools to see what the session is doing before blindly bouncing the database, just because it is taking so long.
hth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
