Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dropping all objects without dropping the schema

Dropping all objects without dropping the schema

From: Jflem <shotzie.fleming_at_gmail.com>
Date: 17 May 2006 13:01:24 -0700
Message-ID: <1147896084.324696.94250@i40g2000cwc.googlegroups.com>


Newbie question here-

How does one drop all of the objects in a given schema without dropping the schema itself? I have looked at various threads and have tried the following with no luck.. I am running 10gR2

select 'drop trigger', trigger_name, trigger_name, ';' from user_triggers;
select 'drop sequence', sequence_name, sequence_name, ';' from user_sequences;
select 'drop table', table_name, tablespace_name, 'cascade constraints;' from user_tables; Received on Wed May 17 2006 - 15:01:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US