What easy method would one use to delete all objects from a schema without deleting the user?
Printable View
What easy method would one use to delete all objects from a schema without deleting the user?
this has been asked so many times you could of searched for it
spool drop.sql
select 'drop ' || object_type || ' ' ||object_name|| ';' from user_objects where object_type in ('TABLE', 'INDEX','VIEW','PACKAGE','PROCEDURE','SYNONYM','FUNCTION','SEQUENCE','TRIGGER','TYPE')
spool off
@drop.sql
probably more obejct_types I have missed