EXPDP error ORA-39001: invalid argument value and ORA-01775: looping chain of synonyms
After issuing expdp command the following errors were occured:
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms
The solution is so simple in this case.
You have to find the synonym which was creating problem.
Issue the following command:
Select owner, object_name, object_type, status
where object_name like '%SYS_EXPORT_%';
Drop the synonym or all the synonym found in this query.
drop public synonym SYS_EXPORT_SCHEMA_01;
Now run the expdp command again.
Happy to help !!!