Thanks for all your help. Dropping objects first and dropping user later really helped me reducing the time. It took ony 1 hr to drop the user (rather than 5+hrs with objects) Stephane Faroult <sfaroult@xxxxxxxxxxxx> wrote: Raj, Drop user objects first, it's usually MUCH faster. SF 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.