Oracle synonym loop chain problem solution

Oracle synonym loop chain problem solution

[SQL] 1. First check whether there is a loop synonym: select * from dba_synonyms where table_owner = 'test' and synonym_name <> table_name; no record 2. Then query the database objects with no synonym objects: select * from dba_synonyms where table_owner = 'test' and sysnonym_name in (select. synonym_name from dba_synonyms a where. table_owner = 'test' minus select object_name from user_objects) 3. query the query results in the select * from DRILL_PRESON table. If no corresponding object exists for this synonym, an error of ora_01775 is reported. 4. Delete this synonym: drop public synonym DRILL_PRESON.