Cause
Fail export or impdp
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms
ORA-39001, 00000, “invalid argument value”
// *Cause: The user specified API parameters were of the wrong type or
// value range. Subsequent messages supplied by
// DBMS_DATAPUMP.GET_STATUS will further describe the error.
// *Action: Correct the bad argument and retry the API.
Query Dba Objects
|
1 2 3 4 5 |
column OWNER format a10; column OBJECT_NAME format a20; column OBJECT_TYPE format a10; Select owner, object_name, object_type, status from dba_objects where object_name like '%SYS_EXPORT%'; |
|
1 2 3 4 5 6 7 8 |
OWNER OBJECT_NAME OBJECT_TYPE STATUS ---------------------------------------------------------- PUBLIC SYS_EXPORT_FULL_01 SYNONYM VALID PUBLIC SYS_EXPORT_FULL_02 SYNONYM VALID PUBLIC SYS_EXPORT_FULL_03 SYNONYM VALID PUBLIC SYS_EXPORT_FULL_04 SYNONYM VALID PUBLIC SYS_EXPORT_FULL_05 SYNONYM VALID PUBLIC SYS_EXPORT_FULL_06 SYNONYM VALID |
Solution
Drop public Synonym
SQL>
|
1 2 3 4 5 6 |
drop PUBLIC SYNONYM SYS_EXPORT_FULL_01; drop PUBLIC SYNONYM SYS_EXPORT_FULL_02; drop PUBLIC SYNONYM SYS_EXPORT_FULL_03; drop PUBLIC SYNONYM SYS_EXPORT_FULL_04; drop PUBLIC SYNONYM SYS_EXPORT_FULL_05; drop PUBLIC SYNONYM SYS_EXPORT_FULL_06; |
Solution
re run expdp or impdp