1.PROBLEM
conn l123/123user@web;
SQL> select * from rhaaaaf;
select * from rhaaaaf
*
ERROR 在行 1:
ORA-01775: looping chain of synonyms
2.CHECK ERROR MESSAGE
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 the operation.
3.FIND ERROR
conn sys/dba
col object_name format a12
SELECT object_name,object_type,owner from dba_objects
where object_name='RHAAAAF';
OBJECT_NAME OBJECT_TYPE OWNER
------------ -------------------------------------- -------
RHAAAAF TABLE SYS
RHAAAAF SYNONYM PUBLIC
RHAAAAF TABLE SYSTEM
SQL> drop table system.rhaaaaf;
Table dropped.
SQL> drop table sys.rhaaaaf;
Table dropped.
problem resolved.
留言列表
