Default: FALSE
Purpose
The NO_INDEX_ERRORS
parameter determines whether indexing errors are tolerated during a direct path load.
Syntax and Description
NO_INDEX_ERRORS=[TRUE | FALSE]
A setting of NO_INDEX_ERRORS=FALSE
means that if a direct path load results in an index becoming unusable then the rows are loaded and the index is left in an unusable state. This is the default behavior.
A setting of NO_INDEX_ERRORS=TRUE
means that if a direct path load results in any indexing errors, then the load is aborted. No rows are loaded and the indexes are left as they were.
Restrictions
The NO_INDEX_ERRORS
parameter is valid only for direct path loads. If it is specified for conventional path loads, then it is ignored.
Example
NO_INDEX_ERRORS=TRUE