BL_SKIP_INDEX_MAINTENANCE= Table Option

Specifies whether to perform index maintenance on the bulk load.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within theBULKOPTS= Table Option
Data source: Oracle

Syntax

BL_SKIP_INDEX_MAINTENANCE= YES | NO

Arguments

YES

specifies to stop index maintenance on the load. This causes the index partitions that would have had index keys added to them to be marked Index Unusable. The index segment is inconsistent with the data it indexes. Index segments that are not affected by the load retain the Index Unusable state that they had prior to the load.

NO

specifies that index maintenance is performed on the load. This is the default value.

See Also

Table Options: