Home » SQL & PL/SQL » SQL & PL/SQL » Drop User takes more time
Drop User takes more time [message #22578] Thu, 17 October 2002 11:35 Go to next message
Muthu
Messages: 58
Registered: August 2000
Member
I used

drop user username cascade;

but it takes more time to drop the user. Is there way, where i can force the drop user to make it faster???
Why is it like this???

can anyone give me some details about this...

thanks,

Report message to a moderator

Re: Drop User takes more time [message #22580 is a reply to message #22578] Thu, 17 October 2002 12:13 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Well it need to drop all the objects owner by the schema. If some of those objects (tables and indexes) have many extents, then they will take longer to drop.

Report message to a moderator

Previous Topic: Updating Ref Cursor
Next Topic: Which query would execute faster?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 06:06:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.