Re: drop user cascade

Michael McGarrigle wrote:
>
> I am noticing that running a
> "drop user cascade" on one of our databases is taking over 15 hours.
> There are many tables in the database but 15 hours sounds excessive.
> Does anyone have any ideas on what I may be able to do to speed this up?
>
> TIA
>
> --
> Michael McGarrigle mjm_at_barwonwater.vic.gov.au
> Information Systems Barwon Water
> 61-67 Ryrie St Geelong Phone: +61 352 262326
> Victoria 3220 Australia Fax: +61 352 218236

Because its a single statement it needs to be able to be rolled back if something goes wrong - thats a lot of stress on your system....You might find it a lot faster to drop the user's objects first and then drop the user.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse