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:
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.