Friday, October 24, 2014

ORA-39083 object type type failed to create with error impdp

Today I was trying to import a schema dump using datapump utility and I got below mentioned error during the import :-

Error Message:
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:

CREATE TYPE "AMIT"."TEST_TYPE"   OID '8E21EF4C1F6EF167E04011AC99643EB0' IS TABLE OF VARCHAR2(40);

Cause :- 

Object Identifier has to be unique in a database. Above statement uses OID of old schema to create object in new schema.

Solution :-

1. Rerun the failed sql like below 

CREATE TYPE "AMIT"."TEST_TYPE"  TABLE OF VARCHAR2(40);

2. Best Solution is to use transform=oid:n in impdp statement.

I hope this article helped you

Regards,
Amit Rath

1 comment: