PC單機最強魔人

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.