ORA-01775 - Looping chain of synonyms

Your rating: None Average: 3.9 (12 votes)

I Never had this error before while trying to SELECT from a table, but there is always fist time for everything I guess. So, after few minutes of troubleshooting I found out that there is a synonym for the table on DBA_SYNONYMS table but the actual table object doesn't exist on DBA_OBJECTS table.

How did this happen? Well, my guess is someone dropped the table but never did the same for the synonym. So, the synonym ends up referencing itself when ever you select from that table and thus the “Looping chain of synonyms".

To solve the problem, you need to drop the synonym associated to the table you are selecting from and then rebuild your table. Same thing applies to views.

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Guest's picture
Guest (not verified)
Re: ORA-01775 - Looping chain of synonyms

I encountered this error because I forgot to qualify the table name for which I was creating a public synonym with the table owner.

I had
create public synonym for tablename;

I should have had

create public synonym for tableowner.tablename;

shiv4uall's picture
User offline. Last seen 9 years 43 weeks ago. Offline
Joined: 11/18/2008
Posts: 8
Re: ORA-01775 - Looping chain of synonyms

This happens most times when you recreate a VIEW using peoplesoft appdesigner.Your guess is absolutely correct.
Good post...

Regards
Shiva

Krishna's picture
Krishna (not verified)
Re: ORA-01775 - Looping chain of synonyms

Thanks a lot.. It surely helped me solve my problem.. someone had recreated the table without dropping the synonym first.
Krishna

Guest's picture
Guest (not verified)
Re: ORA-01775 - Looping chain of synonyms

Hi ,

I got the same issue as yours where I have created public synonym on table without specifying table owner under the same owner schema.

But I am unable to look into table data as it shows :
"SP2-0749 : cannot resolve circular path of synonym"

how did you resolve this issue?
I am not able to drop the synonym as it throws :
"ORA-01434: Private synonym to be dropped does not exist"