Thursday, September 6, 2012

ORA-39083/ORA-02304 during impdp

Error :

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

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

solution:

impdp again with parameter transform=OID:n

Example :

impdp username/password@SID DIRECTORY=DMP LOGFILE=impdp.log transform=OID:n
DUMPFILE=%.dmp

3 comments:

  1. Hi Iam facing this error in 11R2....can i go ahead with same solution ?

    ReplyDelete
  2. Refer to
    DataPump Import Of Object Types Fails With Errors ORA-39083 ORA-2304 Or ORA-39117 ORA-39779 [ID 351519.1]

    ReplyDelete