Link to home
Start Free TrialLog in
Avatar of tonydba
tonydba

asked on

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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

I believe that means it is a partitioned index.  If so you need to look in dba_ind_partitions.
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tonydba

ASKER

not applicable make sense.
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