tough time dropping a user

From: raja rao <raja4list_at_yahoo.com>
Date: Sun, 9 Oct 2005 23:23:09 -0700 (PDT)
Message-ID: <20051010062309.11430.qmail@web31406.mail.mud.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 10 2005 - 01:25:10 CDT