Re: Drop user takes too much time !!

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 18 Aug 1999 18:44:50 +0800
Message-ID: <37BA8EA2.3615@yahoo.com>

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.

drop all the tables with cascade constraints and then drop the user --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Aug 18 1999 - 05:44:50 CDT