What easy method would one use to delete all objects from a schema without deleting the user?
Rick 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 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
Last edited by davey23uk; 09-20-2003 at 04:22 PM.
Forum Rules