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 responses to “ORA-39083/ORA-02304 during impdp”

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

    Like

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

    Like

  3. Osama, God bless

    Like

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.