Re: Drop all objects

It can take a long time, particularly when dropping all of the segments. This was due to the recursive SQL calls to SYS.UET$ and SYS.FET$. But things improved dramatically with LMTs. Have you tried a similar operation when the user's segements where on LMTs? You should seen a noticable improvement.

HTH,
Brian

Luc Gyselinck wrote:
>
> My experience, which goes back to Oracle 6, has leared me that the use of
> this statement can take a LOOONG time.
>
> I always use the following approach:
>
> select 'drop '||object_type||' '||object_name||';'
> from user_objects
> where object_type NOT IN ('PACKAGE BODY','TRIGGER','INDEX')
> /
> (may need some refinements)
>
> spool it to a file and run that file
>
> and finally, when most (if not all) of the objects are dropped, use the DROP
> USER statement.
>
> (indexes, triggers are automagicaly dropped when the table is dropped,
> package bodies when the package specification is dropped)
>
> "Alan" <alan_at_erols.com> wrote in message
> news:bm1mel$h5pn8$1_at_ID-114862.news.uni-berlin.de...
> > Against my better judgment, but...
> >
> > DROP USER <username> CASCADE;
> >
> > Learn where to look for answers:
> >
> > tahiti.oracle.com
> >
> > for one.
> >
> > "Gordon T. Wu" <wutao19_at_yahoo.com> wrote in message
> > news:_TYgb.252$Er.30796_at_mencken.net.nih.gov...
> > > Hi Group:
> > >
> > > Can anybody tell me what is the oracle command to drop a schema (and all
> > > objects under it).
> > > For some reason I can't seem to find it on google.
> > >
> > > Thanks a lot
> > >
> > > Gordon
> > >
> > >
> >
> >

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"