Re: tough time dropping a user
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: raja4list@xxxxxxxxx, "oracle list" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Oct 2005 04:58:42 -0700
Check if some other process is using dbms_pipe; I have seen that
interfere with drop user command.
HTH
GovindanK
On Sun, 9 Oct 2005 23:23:09 -0700 (PDT), "raja rao"
<raja4list@xxxxxxxxx> said:
>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
