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@xxxxxxxxx> 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