Team,
Please suggest if the below process of disbaling or marking an Index unusable and enabling the index is correct
Mark An Index As Unusable or disabling an index:
Alter index Index_name unusable;
.
Enabling an Index :
alter index Index_Name rebuild nologging;
alter index index_Name rebuild online;
let me know which one is correct among the above 2 index enabling statments
PLease let me know if the above process is correct or else am i missing anything here:
Initially I thought of DOing like "alter index inx_name disable" and then "alter index inx_name enable", but i was getting an error message as invalid alter index stmt while disabling the index.
Any recommendations or suggestions most welcome
Message was edited by: 622930
alter index index_Name rebuild online;
let me know which one is correct among the above 2 index enabling statments