Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Dropping all objects without dropping the schema
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