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_at_gmail.com> 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
Received on Mon Oct 03 2005 - 14:32:24 CDT
