|
[oracle-l]
||
[Date Prev]
[10-2005 Date Index]
[Date Next]
||
[Thread Prev]
[10-2005 Thread Index]
[Thread Next]
Re: Relocating the partitions of an index on a composite partitioned table.
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: Rodd.Holman@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 3 Oct 2005 12:58:23 -0700 (PDT)
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
|
|
