Wednesday, 4 November 2015

ORA-39083 and ORA-02304 error during impdp

While importing using data pump get below error ora-39083 and ora-02304. Which cause some object are not created or skip in impdp opration.






Cause:   

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

solution:

 Add parameter transform=OID:n  in your par file and import again 

Reference: 


http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm

No comments:

Post a Comment