deleting all objects from a schema.
What easy method would one use to delete all objects from a schema without deleting the user?
Sigh.....those were the days my friend, I thought they'd never end.
I too remember when this place was coo.
this has been asked so many times you could of searched for it
select 'drop ' || object_type || ' ' ||object_name|| ';' from user_objects where object_type in ('TABLE', 'INDEX','VIEW','PACKAGE','PROCEDURE','SYNONYM','FUNCTION','SEQUENCE','TRIGGER','TYPE')
probably more obejct_types I have missed
Last edited by davey23uk; 09-20-2003 at 05:22 PM.
Click Here to Expand Forum to Full Width