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;
SQL> drop table SYSTEM.SYS_IMPORT_SCHEMA_01 purge;
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.
2 thoughts on “impdp ORA-1775 Looping Chain Of Synonyms”
Thanks this was really usefull i had a similar problem with the exdp and drop the bad synonym and that was it, thanks for the help.
Thanks for your blog. We had a public synonym that was causing this issue with impdp.