Oracle has ORA-01775: A synonym loop chain problem

Oracle has ORA-01775: A synonym loop chain problem

1. When you use a program to connect or use plsql to query synonyms, if there is a problem like ora-01775: the loop chain of synonyms.

It is generally because there is a synonym, but there is no corresponding object for the synonym.

2. check whether there is a synonym for a loop.

Select * fromdba_synonyms
Wheretable_owner = 'test'

And synonym_name <> table_name;

No records.

3. Check the database objects with no synonym objects.

Select * fromdba_synonyms
Wheretable_owner = 'test'
And
Synonym_namein
(Selecta. synonym_namefromdba_synonyms awherea. table_owner = 'test'
Minus
Selectobject_namefromuser_objects)

4. query the query results.

Select * fromDRILL_PRESON

If the synonym does not have an object, it will package an error for the ora-01775

5. Delete the synonym

DroppublicsynonymDRILL_PRESON