Oracle7 Server Utilities
Rejected Records
A record is rejected if it meets either of the following conditions:
- Upon insertion the record causes an Oracle error (such as invalid data for a given datatype).
- SQL*Loader cannot determine if the data is acceptable. That is, it cannot determine if the record meets WHEN-clause criteria, as in the case of a field that is missing its final delimiter.
If the data can be evaluated according to the WHEN-clause criteria (even with unbalanced delimiters) then it is either inserted or rejected.
If a record is rejected on insert, then no part of that record is inserted into any table. For example, if data in a record is to be inserted into multiple tables, and most of the inserts succeed, but one insert fails; then all the inserts from that record are rolled back. The record is then written to the bad file, where it can be corrected and reloaded. Previous inserts from records without errors are not affected.
The log file indicates the Oracle error for each rejected record. Case 4 has an example of rejected records.
Integrity Constraints
All integrity constraints are honored for conventional path loads. On the direct path, some constraints are unenforceable. See Chapter 8 for more details.