Re: Dropping all objects without dropping the schema

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Fri, 19 May 2006 07:47:16 GMT
Message-ID: <446d76b5.5266015@news.hetnet.nl>

On Wed, 17 May 2006 20:46:34 GMT, Brian Peasland <oracle_dba_at_nospam.peasland.net> wrote:

snip

>Try the following:
>
>SPOOL drop_me.sql
>SELECT 'DROP '||object_type||' '||object_name||';'
>FROM user_objects;
>SPOOL off
>@drop_me
>
>
>

snip

If you want this script to work in one go, put in

CASCADE CONSTRAINTS if the object is a table,and

INCLUDING TABLES CASCADE CONSTRAINTS if the object is a cluster.

Regards, Jaap. Received on Fri May 19 2006 - 02:47:16 CDT