Re: Drop all objects

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
> >
> >
>
>
Received on Wed Oct 08 2003 - 17:19:54 CDT