Thursday, November 3, 2016


impdp: ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal


Error Message:
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "TEST"."TTTTT"   OID '8E21EF4C1F6EF167E04011AC99643EB0' IS TABLE OF VARCHAR2(40);

This error happened when expdp and impdp a schema to a new one in the same database. 

Cause: OID should be unique in a database. the OID in the impdp create statemene was used by old schema. 

solution: 

1. remove the OID from failing sql and rerun it manually.
2. impdp again with parameter transform=OID:n

No comments:

Post a Comment