Wednesday, May 23, 2012

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

reference:
http://www.franklinfaces.com/Topic173-54-1.aspx

1 comment: