I think (and I am pretty shure) you are right. Today, indeed, we use LMT's
and it should be faster. But I am so used to use the procedure in my
previous post. Next time, I'll try it the 'normal' way : DROP USER <user>
CASCADE
Thanks,
Luc
"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:3F85626D.8B88ACB9_at_remove_spam.peasland.com...
> 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"
Received on Thu Oct 09 2003 - 15:03:54 CDT
