OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ABOUNT INDEX STATUS

Mon, 24 September 2007 20:19

lzfhope
Messages: 69
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?

Mon, 24 September 2007 21:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

N/A means Not Applicable
If I recall correctly, this occurs on partitioned indexes.

Mon, 24 September 2007 23:51

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Tue, 25 September 2007 02:44

lzfhope
Messages: 69
Registered: July 2006

Member

I see.
Thank you !

Previous Topic:	Problem starting logminer
Next Topic:	database upgrade from 9i

Goto Forum:

]

Current Time: Thu May 21 20:45:41 CDT 2026