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
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
It definitely hepled
ReplyDelete