Home » RDBMS Server » Server Administration » Indexes (Oracle ver 9i)
Indexes [message #304343] Tue, 04 March 2008 23:35 Go to next message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Hi all,

What is the table that can give stats on whether an index is a global or a local index for the partitions and also whether they are usable or unusable?

Thanks in advance.



Re: Indexes [message #304347 is a reply to message #304343] Tue, 04 March 2008 23:51 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
dba_indexes, dba_ind_columns, dba_objects, v$parameter and v$database.


regards,
Re: Indexes [message #304365 is a reply to message #304343] Wed, 05 March 2008 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_part_indexes.locality
dba_indexes.status
dba_ind_partitions.status

Regards
Michel
Re: Indexes [message #304634 is a reply to message #304343] Wed, 05 March 2008 23:19 Go to previous message
babuanna
Messages: 28
Registered: October 2007
Junior Member
Thanks Michel. It helped.
Previous Topic: Audit & Trace Database Changes
Next Topic: Missing u0902000.sql file when upgrading?
Goto Forum:
  


Current Time: Sat Dec 10 22:27:55 CST 2016

Total time taken to generate the page: 0.08266 seconds