ORA-01775: looping chain of synonyms

#1. you can run the query

SELECT table_owner, table_name, db_link
  FROM dba_synonyms 
 WHERE owner        = 'PUBLIC'
   AND synonym_name = <<synonym name>>

to see what the public synonym currently points at.

After debugging I figured out that the actual tables were misssing, which I was referring using synonyms. So I suggest - first check that whether the tables exists!! :-))


#2. Second possible reason: You have created a series of synonyms that resulted in a circular reference.

A circular reference can occur as follows:

Create SYNONYM syn1 for syn2;

Create SYNONYM syn2 for syn3;
Create SYNONYM syn3 for syn1;