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