Re: Drop user takes too much time !!

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 16 Aug 1999 14:13:02 -0700
Message-ID: <37B87EDD.719733D4@us.oracle.com>

Sunit

The only other alternative is to drop the user's objects explicitly, then drop the user. This can be simplified if the objects are in their own tablespaces, because then you can drop them.

HTH. Pete

sjoshi_at_ingr.com wrote:

> Hello All
> I'm trying to drop a user and all associated objects using
> drop user A cascade; and somehow the process is taking too long. I know
> for fact that this user has a lot of data. Is there a faster way to
> drop this user??
>
> thanks
> Sunit
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Regards

Pete

Received on Mon Aug 16 1999 - 16:13:02 CDT