Table Load Information - Oracle 8i

The Datafile Information Section appears only for datafiles with data errors, and provides the following entries:

  • SQL*Loader and Oracle data record errors
  • Records discarded

For example:

Record 2: Rejected - Error on table EMP. ORA-00001: unique constraint <name> violated Record 8: Rejected - Error on table EMP, column DEPTNO. ORA-01722: invalid number Record 3: Rejected - Error on table PROJ, column PROJNO. ORA-01722: invalid number

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 8i Topics