Wednesday, April 29, 2015

ORA-39001: invalid argument value ORA-01775: looping chain of synonyms

Got above issue while import a schema using IMPDP



DataPump Import Results In ORA-39001 Invalid Argument Value ORA-1775 Looping Chain Of Synonyms (Doc ID 459151.1)


Initially I checked for synonyms like SYS_IMPORT_SCHEMA, which resulted in no rows.
But we have to check for all the synonyms present for the IMPORT.

These synonyms are left over of the improper termination of imports 



diudbs01:sint4> select owner, object_name, object_type, status from dba_objects where object_name like '%SYS_IMPORT%';

OWNER                    OBJECT_NAME                    OBJECT_TYPE         STATUS
------------------------ ------------------------------ ------------------- -------
PUBLIC                   SYS_IMPORT_FULL_01             SYNONYM             VALID
PUBLIC                   SYS_IMPORT_FULL_02             SYNONYM             INVALID

diudbs01:sint4> drop public synonym SYS_IMPORT_FULL_02 ;

Synonym dropped.


diudbs01:sint4> drop public synonym SYS_IMPORT_FULL_01;

Synonym dropped.



Import ran fine after that

No comments:

Post a Comment