Tuesday, June 10, 2008

ORA-01775: looping chain of synonyms

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

ORA-01775: looping chain of synonyms
This error is very similar to ORA-00980, this specific error is returned when the underlying object, bearing the same name as the synonym, is either renamed or dropped. At that point an attempt to resolve the name pointed to by the synonym only returns the synonym itself, resulting in a circular reference, hence the error message.

Refer to the aforementioned blog entry for applicable examples or see message translations for ORA-01775 and search additional resources.
at

3 comments:

  1. AnonymousWednesday, 11 June, 2008

    Keep these coming. Your blog is very interesting.

    ReplyDelete
  2. AnonymousWednesday, 25 June, 2008

    THANKS A LOT DUDE ... i was missing this case

    ReplyDelete
  3. AnonymousWednesday, 07 January, 2009

    I received this same error because of privileges through a database link in a materialized view. Make sure the privileges are corrent on the master site

    ReplyDelete

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio