TRIGGER- ORA-01775: looping chain of synonyms
617891Apr 30 2008 — edited May 6 2008Hi,
I have 2 schemas in one db . In this i have one SYSDEV another CLIDEV.
In SYSDEV I created db link and all synonyms . Later i dropped the SYSDEV schema bcz of some reasons.
Again i created SYSDEV, but when i am using to create SYNONYM its saying that synoyms already exist with the name. I think when i drop the USER Synonyms were not gone.
In another db i have on schema name GRL , the synonyms created on this GRL objects
Does i miss anthing on the system . Why synonyms not deleted ?
But when i am trying to create a trigger i am getting this error. Please tell does i miss any thing on this
.
SQL> sho errors
Errors for TRIGGER "CLIDEV11G"."TI_LINK_TBL":
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/7 PL/SQL: SQL Statement ignored
3/19 PL/SQL: ORA-01775: looping chain of synonyms
6/7 PL/SQL: SQL Statement ignored
6/14 PL/SQL: ORA-01775: looping chain of synonyms