impdp ORA-1775 Looping Chain Of Synonyms

After importing my dump file, I have reviewed my log file and found the below error being thrown multiple times:

ORA-01775: looping chain of synonyms

My oracle version where I faced the problem is: 11.2.03

To resolve this problem:

SQL> select owner, object_name, object_type, status from dba_objects where object_name like ‘%SYS_IMPORT_SCHEMA_01%’;

The result of the query:

master tables

So I have dropped these tables:

SQL> drop table SYS.SYS_IMPORT_SCHEMA_01 purge;

Table dropped.

SQL> drop  table SYSTEM.SYS_IMPORT_SCHEMA_01 purge;

Table dropped.

Then, try to re-run impdp command again.

Remark: Those tables are orphan master tables due to the interruption of the impdp process. Normally master tables would be “dropped” after finishing the impdp.

Advertisement