How to compile/drop public synonym? « Oracle Spin – Flimatech Blog

How to compile/drop public synonym? « Oracle Spin – Flimatech Blog

瀏覽:700
日期:2025-04-30
-- compile public synonym that are invalid Select 'alter public synonym '||object_name||' compile;' From dba_objects Where status 'VALID' And owner = 'PUBLIC' And object_type = 'SYNONYM'; -- drop public synonym that are invalid Select 'drop public ......看更多