Oracle Error Codes

looping chain of synonyms

Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:CREATE SYNONYM s1 for s2 CREATE SYNONYM s2 for s3 CREATE SYNONYM s3 for s1

How to Solve :

Change one synonym definition so that it applies to a base table or view and retry the operation.