OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Indexes (Oracle ver 9i)

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

Indexes [message #304343]

Tue, 04 March 2008 23:35

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.

Report message to a moderator

Re: Indexes [message #304347 is a reply to message #304343]

Tue, 04 March 2008 23:51

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

dba_indexes, dba_ind_columns, dba_objects, v$parameter and v$database.

regards,

Report message to a moderator

Re: Indexes [message #304365 is a reply to message #304343]

Wed, 05 March 2008 00:24

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

Senior Member
Account Moderator

dba_part_indexes.locality
dba_indexes.status
dba_ind_partitions.status

Regards
Michel

Report message to a moderator

Re: Indexes [message #304634 is a reply to message #304343]

Wed, 05 March 2008 23:19

babuanna
Messages: 28
Registered: October 2007

Junior Member

Thanks Michel. It helped.

Report message to a moderator

Previous Topic:	Audit & Trace Database Changes
Next Topic:	Missing u0902000.sql file when upgrading?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 24 19:33:28 CST 2025