• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

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
0
tonydba
Asked:
tonydba
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
I believe that means it is a partitioned index.  If so you need to look in dba_ind_partitions.
0
 
sdstuberCommented:
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now