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.

2 thoughts on “impdp ORA-1775 Looping Chain Of Synonyms

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s