name meaning

what is N/A means



select index_name,status,owner from dba_indexes where status!='VALID';

Index Name                     STATUS   Index Owner
------------------------------ -------- ------------------------------
WRH$_FILESTATXS_PK             N/A      SYS
WRH$_SQLSTAT_PK                N/A      SYS
WRH$_SQLSTAT_INDEX             N/A      SYS
WRH$_SYSTEM_EVENT_PK           N/A      SYS
WRH$_WAITSTAT_PK               N/A      SYS

Index Name                     STATUS   Index Owner
tonydbaAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
N/A means "not applicable"

slightwv is correct,  the status of the index as a whole is "not applicable" because each partition of the index has its own status
0
 
slightwv (䄆 Netminder) Commented:
I believe that means it is a partitioned index.  If so you need to look in dba_ind_partitions.
0
 
tonydbaAuthor Commented:
not applicable make sense.
0
 
sdstuberCommented:
Did you really only need the abbreviation explained or did you also need the context in which a status was not applicable?  If you needed the context as well then slightwv should get a split
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.