|
[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: bcoulam@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 3 Oct 2005 12:29:03 -0700 (PDT)
We noticed this too. It seems odd, but it is perfectly
normal. The granularity of a composite partitioned
table is the subpartition. If you rebuild 'ALL' the
subpartitions of a partition in a different
tablespace, you should be OK, since the partition
itself does not contain any data, its subpartition(s)
has the data.
- Deepak
--- Bill Coulam <bcoulam@xxxxxxxxx> wrote:
> It turns out that one *cannot rebuild* (and
> therefore relocate as well) the
> partitions of a composite partitioned index. If you
> try, you get
> ORA-14287: cannot REBUILD a partition of a
> Composite Range partitioned
> index
> The Oracle docs confirm:
> The ALTER INDEX ... REBUILD PARTITION statement
> rebuilds one partition of
> an index. It cannot be used on a range-hash
> partitioned table.
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
|
|
