ORA-26028: index initially in unusable state

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
GIDs
Participant
Posts: 16
Joined: Sun May 23, 2004 2:39 pm
Location: San Francisco

Post by GIDs »

An Oracle index becomes UNUSABLE when you load data, but the index is not updated with the new records. Here is a sequence of events...

1. Disable the PK (with a KEEP clause), this keeps the associated INDEX
2. When fresh data is loaded, the index still is in UNUSABLE state
3. So, we need to rebuild the index.

ALTER INDEX index_name REBUILD TABLESPACE tbl_spc_name
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”