Oracle Database Discussions

Hi ,
Version 9I,

ABC_DEF is a partitioned tabled.

I could find ABC_DEF_PK ( PRIMARY KEY) and its unusable...i made is usable..

Could any one expalin me why the status in DBA_IND_PARTITIONS AND DBA_INDEXS status is different ...what exactly is N/A means

SQL> select distinct status from dba_ind_partitions where index_name = 'ABC_DEF_PK';

STATUS

--------

UNUSABLE

USABLE

SQL> SELECT index_name, status FROM dba_INDEXES WHERE INDEX_NAME='ABC_DEF_PK';

INDEX_NAME STATUS
------------------------------ --------
ABC_DEF_PK N/A

SQL> alter index arborbp1.ABC_DEF_PK rebuild partition ABC_DEF_2009_12_28;

Index altered.

SQL> select distinct status from dba_ind_partitions where index_name = 'ABC_DEF_PK'

STATUS
--------
USABLE

SQL> SELECT index_name, status FROM dba_INDEXES WHERE INDEX_NAME='ABC_DEF_PK';

INDEX_NAME STATUS
------------------------------ --------
ABC_DEF_PK N/A


Notice how the status in DBA_INDEXES remained the same even while one of the partitions was unusable.