Posted: Thu Feb 03, 2005 5:53 pm
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
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