If an index in an Index
Unusable state is encountered, by default, it is skipped and the load
operation continues. This allows the SQL*Loader to load a table with
indexes that are in an unusable state before beginning the load. Indexes
that are not in an unusable state at load time are maintained by the
SQL*Loader. Indexes that are in an unusable state at load time are
not maintained and remain in an unusable state at load completion.
If this bulk load option
is not specified, the default value is specified in the Oracle database
configuration parameter, SKIP_UNUSABLE_INDEXES. This value is specified
in the initialization parameter file. The BL_SKIP_UNUSABLE_INDEXES
bulk load table option overrides the value of the SKIP_UNUSABLE_INDEXES
configuration parameter in the initialization parameter file.