After running the uninstaller clean up the schema. Useful in cases of migration when sysadmin’s password can’t be legally extracted from the Oracle dba and you need to crack on.
set heading off
set feedback off
spool dropobj_x.sql
select ‘drop ‘||object_type||’ ‘||object_name||’ ;’
from user_objects
where object_type <> ‘INDEX’
and object_type <> ‘DATABASE LINK’
and object_type <> ‘PACKAGE BODY’
and object_type <> ‘TRIGGER’
and object_type <> ‘LOB’
order by created;
spool off
set heading on
set feedback on
