Imp-00019 imp-00003 ORA-00001

Time: 2008/03/31
Author: skate

Because impdp has many bugs and errors occur when I import data, I use the IMP tool.

IMP skate/password fromuser = skate touser = skate_new file =/home/Oracle/admin/omovo/dpdump/compassweb. dmp ignore = y
The following error is prompted:

Imp-00019: Row rejected due to Oracle Error 1
Imp-00003: Oracle Error 1 encountered
ORA-00001: unique constraint (movo_new.compassindexplace_pk) violated

We can see from the error that there are duplicate data. After Google, we learned that if the table does not have constraints, we can use ignore = Y. to overwrite the table.
If constriants exists, you need to delete the original data first, and then in IMP. Otherwise, the above error will be prompted.

My approach is to delete an existing table, and then import all the results in IMP OK.

 

--- End ----