Drop all synonym from owner
Drop all synonym from owner
set head off
set newpage none
set pagesize 9999
spool drop_synonym.sql
select ‘drop synonym ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from dba_objects where OWNER =’OWNER’ and OBJECT_TYPE =’SYNONYM’;
spool off
No comments yet
DBA 