Re: Rebuilding partioned indexes

From: Adam Musch <ahmusch_at_gmail.com>
Date: Fri, 5 Mar 2010 08:45:55 -0600
Message-ID: <516d05a1003050645v5bd5886aq7bdd0f951087b757_at_mail.gmail.com>

A partition of a subpartitioned index has a non-applicable status -- it's neither usable nor unusable, as the status of its subpartitions is what's relevant. Similarly, you can't rebuild a partition of a subpartitioned index, you must rebuild the subpartitions.

On Thu, Mar 4, 2010 at 5:16 PM, Saad Khan <saad4u_at_gmail.com> wrote:
> Please ignore my lack of knowledge with the partitions and its handling.
> We've a big bunch of tables with both partitioned and subpartitioned
> indexes. And some of them were in the state of N/A as part of ETL process
> which failed due to some reason. So I tried to rebuild the partitioned
> indexes but came across the error ora-14827:cannot rebuild a partition of a
> composite range partitioned index.
>
> I rebuilt the entire subpartitions and I can see from
> user_ind_subpartitions, they are all in USABLE state but the status in
> user_ind_partitions is still showing N/A and same status is from
> user_indexes for the indexes that were unusable earlier. Is this a normal
> behavior for partitioned indexes? or do I need to rebuild partitioned
> indexes in some other way? Thanks for the help.
>

-- 
Adam Musch
ahmusch_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 05 2010 - 08:45:55 CST