www.oradev.com
  Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages
  ORA-01775

Common error messages

TNS connection closed
IO error writing block
Resource busy
Invalid character
Invalid datatype
Syntax error
Looping chain synonyms
Resolve connect identifier
number too large for buffer
All error messages



  OraDev.com

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.
For example, the following definitions are circular: CREATE SYNONYM s1 for s2;
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
or
CREATE SYNONYM s4 for s4

Check your synonyms with:
select * from all_synonyms where synonym_name = 'name' or table_name = 'name';