Export/Import from a database containing Object Types

If you are performing and Export/Import from a source database that contains types, you may encounter the error:

ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE ""."object_type_name"   OID '8FD43617684FA1F6E033A625D854A1F6' AS OBJECT
(
   parm_01             varchar2(18),
   parm_02             varchar2(50)
);

Each type has an OID. If you create an object type and do not specify an OID, Oracle generates an OID and assigns it to the type.

To resolve this error, you need to transform the OID by adding the below option to you IMPDP command:

transform=OID:n:type

The type object will now get a new OID in the target database.