Re: Relocating the partitions of an index on a composite partitioned table.

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Mon, 3 Oct 2005 12:58:23 -0700 (PDT)
Message-ID: <20051003195823.32070.qmail@web52801.mail.yahoo.com>

Do you have a local PK or a global ?

I mean in case of LOCAL, does the 1st two columns of the PK, include the partition_key and subpartition_key columns?

• Rodd Holman <Rodd.Holman_at_gmail.com> wrote:

> I agree, it appears to work, and even reports that
> it works.
> However, applications depending on those indexes
> (particularly if it's a
> PK or UK)
> will fail. I did just what you described below on
> one table that I
> moved using
> alter table move subpartition ...
> and then rebuild index subpartion.
> The load the following day failed because the PK on
> the table was unusable.
> It took dropping and recreating the index to fix.
>
> Rodd
                

---

Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

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

Received on Mon Oct 03 2005 - 15:01:45 CDT