4 Replies Latest reply: Jan 22, 2013 4:57 PM by Gary Graham-Oracle RSS

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

    AnkitV
      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.