Ora-01775 looping chain of synonyms

今天用户运行查询语句的时候遇到了Ora-01775错误,查看了一下帮助得到如下解释:

ORA-01775 looping chain of synonyms
Cause: 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
Action: Change one synonym definition so that it applies to a base table or view and retry [...]