This discussion is archived
4 Replies Latest reply: Jan 22, 2013 2:57 PM by Gary Graham RSS

Import data using SQL Developer doesn't give failed records !

AnkitV Newbie
Currently Being Moderated
Hi All

I am using SQL Developer 3.0.04.
While using SQL Developer for data import from a csv file in to a 10g R2 table, it loads data very fast with no issues when everything is fine.
But when there is some constraint violation, like primary of foreign key violation, it doesn't give the records which failed to load, it just gives ALL insert statements.

Is there any way to get ONLY the records which failed to load using SQL developer ? or some other method.

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points