Ora-01775: circulation chain of synonyms

1. First check whether there is a synonym for loop: Select * From dba_synonyms where Table_owner = 'test' and synonym_name <> Table_name; no record 2. query the database objects with no synonym objects: Select * From dba_synonyms where Table_owner = 'test' And sysnonym_name in (select a. synonym_name from dba_synonyms Where a. table_owner = 'test' Minus Select object_name from user_objects ) 3. query the query results. Select * From drill_preson If the synonym does not have the corresponding object, the error ora_01775 is returned. 4. Delete this synonym: Drop public synonym drill_preson