Unique Index Is Going Unusable State After Data Loading Using SQL*Loader
(Doc ID 2184469.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Index (unique) state changing to unusable status after data loading using SQL*Loader. The steps below are executed to load the data:
1/ disable constraint
2/ load data using SQL*Loader
3/ remove duplicate records
4/ enable constraint
The execution of step 3 fails due to an index in unusable state:
Checking the available indexes and their status from dba_indexes, we have:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|