Re: tough time dropping a user

From: raja rao <raja4list_at_yahoo.com>
Date: Mon, 10 Oct 2005 01:16:39 -0700 (PDT)
Message-ID: <20051010081639.44209.qmail@web31405.mail.mud.yahoo.com>

Thanks,

i will try this option.

Stephane Faroult <sfaroult_at_roughsea.com> wrote: Raj,

Drop user objects first, it's usually MUCH faster.

On Sun, 2005-10-09 at 23:23 -0700, raja rao wrote:
>
> Hi All,
>
> db: 9i
> os: solaris 9
>
> Can some one help me in dropping a user.
>
> Its taking 5 hrs to drop the user.
> It has got several FK relation with other schema objects.
>
> We are using "drop user obt cascade;"
>
>
> Is there any fastest way to drop the user.
>
> Thanks in advance
> Raj
>
> ______________________________________________________________________
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 10 2005 - 03:18:56 CDT