ORA-01775 looping chain of synonyms

在用oracle10g impdp功能的时候提示

ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms

 

用下面的SQL,查出对象已经不存在的同义词,然后删除掉该同义词

 

SELECT *
  FROM DBA_SYNONYMS
 WHERE TABLE_OWNER = '&owner'
       AND SYNONYM_NAME IN (SELECT A.SYNONYM_NAME
                              FROM DBA_SYNONYMS A
                             WHERE A.TABLE_OWNER = '&owner'
                            MINUS
                            SELECT OBJECT_NAME FROM USER_OBJECTS);
posted @ 2012-03-14 09:28  DB&*NIX  阅读(3913)  评论(1编辑  收藏  举报