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
Yes, this parameter I was looking, Thank you
ReplyDelete