Thursday, February 14, 2013

ORA-39083/ORA-02304 during impdp


Was facing the following errors while impdp. Reason for this error is OID should be unique in each DB. In this case, OID in the impdp was using old schema value thus failing.

ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal

Solution is to use transform=OID:n on my impdp parameter.

Example :
impdp username DIRECTORY=DUMP transform=OID:n DUMPFILE=schema.dmp

Now all good!

No comments: