ORA-01775: Looping chain of synonyms

Being good is a habit, life is a process, giving up is a kind of wisdom, and its disadvantage is a kind of favor.

 

 

A synonym error occurs when the base table or view is deleted.

ORA-01775: Looping chain of synonyms

 

Cause: through a series of create synonym statements, a synonym was defined that referred to itself.

 

Action: change one Synonym definition so that it applies to a base table or view and retry the operation.

 

View synonyms in Oracle:

 

Create:

Create public synonym table_name for user. table_name;

Delete:

Drop public synonym table_name;

 

View all synonyms:

Select * From dba_synonyms;

View specific synonyms Based on the synonym Name:

Select * From dba_synonyms where synonym_name = 'searches ';

View specific synonyms Based on the table name:

Select * From dba_synonyms where table_name = 'searches ';

 

View the user's table:

Select table_name from user_tables;