ORA-01775 looping chain of synonyms

最新推荐文章于 2022-01-18 14:25:13 发布

aipibang1266

最新推荐文章于 2022-01-18 14:25:13 发布

阅读量420

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/rambler/archive/2012/03/14/2395370.html

版权

在用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);

转载于:https://www.cnblogs.com/rambler/archive/2012/03/14/2395370.html