How to resolve ORA-39083 error during import

Error:
===========
We came across below ORA error during import of Schema

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

Failing sql is:
CREATE EDITIONABLE TYPE “FMSDEV”.”SAMPLE_TYPE_TABLE” OID ‘025A6EE43DFF210DE0534C01A8C086AA’ AS TABLE OF sample_type;

Cause:
============
OID value of object TYPE should be unique in the database So if we try to import TYPE with SAME OID it will throw this error.

Check for above OID ie ‘025A6EE43DFF210DE0534C01A8C086AA’ already exists in database are not

SQL> select owner,type_oid from dba_types where TYPE_OID=’025A6EE43DFF210DE0534C01A8C086AA’;

OWNER TYPE_OID
————— ——————————–
FMS 025A6EE43DFF210DE0534C01A8C086AA

Here the OID already exists in the database therefore TYPE getting imported should be generated using NEW OID.

Solution:
============
Use TRANSFORM=oid:n parameter with IMPDP to resolve this

impdp schemas=FMSDEV directory=dpump_new dumpfile=EX_FMSDEV.dmp logfile=IM_FMSDEV.log TRANSFORM=oid:n