OraFAQ Forum: Server Administration » How to check partitioned table local indexes is valid

Home » RDBMS Server » Server Administration » How to check partitioned table local indexes is valid (Oracle 10gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check partitioned table local indexes is valid [message #360264]

Thu, 20 November 2008 04:10

bbmonster
Messages: 47
Registered: June 2007
Location: UB

Member

Dear all,

I need to check partitioned table's local indexes is valid.
user_indexes view doesn't work for this. Because its STATUS field value is N/A.

How can I do this?
I am sure there is some view to check. Because when I alter index in the TOAD it shows all "Status of all subpartitions is valid" if all indexes are ok.

Thanks in advance

Report message to a moderator