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

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

      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.