Partitioned Index Becomes Unusable After SQLLDR Conventional Load With Truncate Option (Doc ID 2425156.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

After loading data using the TRUNCATE option into a table with LIST PARTITIONS with CONVENTIONAL load method, LOCAL PARTITION INDEX becomes UNUSABLE

Control File: /controlfile
Data File: /datafile
 Bad File: /badfile
 Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 1
Errors allowed: 51
Bind array: 65500 rows, maximum of 40971520 bytes
Continuation: none specified
Path used: Conventional <<<<<<<<<<<
Silent options: FEEDBACK
Table TABLE1, partition PARTITION1, loaded from every logical record.
Insert option in effect for this partition: TRUNCATE  <<<<<<<<<<<<<

STATUS      INDEX_NAME
------------ -------------------------
UNUSABLE  LOCALIDX2
N/A           IDX1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.