OraFAQ Forum: Server Administration » drop user cascade hangs

Home » RDBMS Server » Server Administration » drop user cascade hangs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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,

Report message to a moderator

Re: drop user cascade hangs [message #110676 is a reply to message #110672]

Wed, 09 March 2005 10:25

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

after the reboot,
is the user still available in the database?
what is your problem here?

Report message to a moderator

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

Report message to a moderator

Previous Topic:	Renaming a schema
Next Topic:	Error creating a new database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 04 03:37:43 CDT 2025