Index on partitionned table in N/A status
420827Dec 20 2007 — edited Jan 26 2012Hi all,
I have one table partitionned on column with date type. And created unique index in 03 columns including the column partitionned, after index creation and i check the status it still oin N/A. I rebuild it for each partition and still in N/A status. My question is, is it normal or not and does it affect performance. If yes how to make it in VALID status, how to rebuild this index to have it valid.
I did the comand bellow to rebuilt this index:
alter index index_name rebuild partition partition_name tablespace tablespace_name;
Thanks a lot.
raitsarevo