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!

identify which sysnonyms throwing ora-01775 looping chain of synonyms error

user097815May 7 2009 — edited May 7 2009

hello all,

I am on 10.2.0.3 (aix)....i have a select statement..when i run that i get the bleow error..
ora-01775 looping chain of synonyms
i know how to fix this, as the select was taken out of a view and its using 20 different table and 35 different synonyms....i know how to fix the problem...but my question is...
is there a way to identify which synonym is causing the trouble ?? any sql or anything ???....
Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2009

Added on May 7 2009

#general-database-discussions

2 comments

961 views