|
  OraDev.com
|
ORA-01775: looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself.
|
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
|
For example, the following definitions are circular:
CREATE SYNONYM s1 for s2;
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
or
CREATE SYNONYM s4 for s4
Check your synonyms with:
select * from all_synonyms where synonym_name = 'name' or table_name = 'name';
|
|
|
|
|
|