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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:32:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.