Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01775: looping chain of synonyms

880047Oct 28 2011 — edited Mar 26 2012

Hi All,

When i am trying to do the explain plan for sql i am getting the error "ORA-01775: looping chain of synonyms". I have public and private synonyms for the table, i am doing the explain plan. After i have done some research on this, i have tried the plan by removing the synonyms on this table, but still getting the same error.
I am working on the 11.2.0.2 linux box.

What i need to do to over come this issue. Please let me know.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2012

Added on Oct 28 2011

#11gr2, #general-database-discussions

13 comments

28,460 views