Home » RDBMS Server » Server Administration » ABOUNT INDEX STATUS
ABOUNT INDEX STATUS [message #269853] Mon, 24 September 2007 20:19 Go to next message
lzfhope
Messages: 67
Registered: July 2006
Member
hi,

I EXECUTED THE SQL BELOW:
select INDEX_NAME,STATUS from user_indexes 

I found the "status" value of one index is "N/A",what does the "N/A" means? How to change that?
Re: ABOUNT INDEX STATUS [message #269857 is a reply to message #269853] Mon, 24 September 2007 21:21 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
N/A means Not Applicable
If I recall correctly, this occurs on partitioned indexes.
Re: ABOUNT INDEX STATUS [message #269879 is a reply to message #269853] Mon, 24 September 2007 23:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, this is that, you get "N/A" on a partitioned index, you have to query user_ind_partitions to get the status of each partition.

Regards
Michel
Re: ABOUNT INDEX STATUS [message #269927 is a reply to message #269857] Tue, 25 September 2007 02:44 Go to previous message
lzfhope
Messages: 67
Registered: July 2006
Member
I see.
Thank you !
Previous Topic: Problem starting logminer
Next Topic: database upgrade from 9i
Goto Forum:
  


Current Time: Sat Dec 10 20:18:15 CST 2016

Total time taken to generate the page: 0.11051 seconds