Home » SQL & PL/SQL » SQL & PL/SQL » 'ignore = y ' still IMP-00019: row rejected due to ORACLE error 1
'ignore = y ' still IMP-00019: row rejected due to ORACLE error 1 [message #18717] Tue, 12 February 2002 03:32 Go to next message
hisham
Messages: 4
Registered: August 2001
Junior Member
i am still getting the same error

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SCOTT.PART_CODE_PK) violated
these are my exp/imp command arguments
exp
exp scott/tiger full = n rows = y compress = y file = file1.dmp log = log1.log
tables = emp
the mesaage in the log1

"export terminated successfully without warnigs"

imp scott/tiger full = n rows = y ignore = y file = d:orantfile1.dmp log = log2.log
tables = emp

i am getting the above mentioned message in log2

where it is going wrong ? Correct me.
hisham
Re: 'ignore = y ' still IMP-00019: row rejected due to ORACLE error 1 [message #18720 is a reply to message #18717] Tue, 12 February 2002 04:20 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

row is rejected due tom primary key constraint.so one thing u can do .first truncate the table then import.it is a warning not error

cheers
pratap
Previous Topic: SQL problem
Next Topic: Inserting data using a view.
Goto Forum:
  


Current Time: Mon Sep 27 04:35:57 CDT 2021