About Me

My photo
Bangalore, India
I am an Oracle Certified Professional working in SAP Labs. Everything written on my blog has been tested on my local environment, Please test before implementing or running in production. You can contact me at amit.rath0708@gmail.com.

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: