Re: URGENT: Rebuild indexes on partitioned tables 9i w2k

Bryan,

If the indexes are partitioned, dba_part_indexes will tell you about them. owner, index_name, table_name, partition_count. For information on the partitions themselves can be found at dba_ind_partitions. Look at index_owner, index_name, partition_name, status and tablespace_name are some of the key things to look at.

Why do you need to rebuild? Are they invalid?

alter index owner.index_a rebuild partition (partition_name) might work. The parenthesis are tricky and a bit inconsistent depending on what you are doing with partitions.

HTH
Stephen

On Tue, 4 Jan 2005 17:55:31 -0700, Bryan Wells <bunjibry_at_gmail.com> wrote:
> I need to rebuild some indexes that reside within partitions. what is
> the syntax to find out what partition an index_a belongs to? from
> dba_indexes? do i need to specify owner (owner.index_a)? really, how
> the heck do I do this. got 5 hours.
>
> wouldnt this be right:
>
> alter index owner.index_a rebuild partition owner.partition_name
>
> please help.
>
> --
> Bryan S Wells - DBA Newbie
> bunjibry_at_gmail.com
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l