Home » RDBMS Server » Server Administration » How to check partitioned table local indexes is valid (Oracle 10gR2)
How to check partitioned table local indexes is valid [message #360264] Thu, 20 November 2008 04:10 Go to next message
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
Re: How to check partitioned table local indexes is valid [message #360273 is a reply to message #360264] Thu, 20 November 2008 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select * from dict where table_name like 'USER%IND%';

Regards
Michel
icon7.gif  Re: How to check partitioned table local indexes is valid [message #360396 is a reply to message #360273] Thu, 20 November 2008 19:18 Go to previous message
bbmonster
Messages: 47
Registered: June 2007
Location: UB
Member

Thank you very much Michel for always be here to help us
Previous Topic: "Snapshot is too old" problem
Next Topic: Granting object privileges to remote users
Goto Forum:
  


Current Time: Sat Dec 03 12:23:47 CST 2016

Total time taken to generate the page: 0.11362 seconds