david.wallace_at_colesmyer.com.au (David Wallace) wrote in message news:<162bbe29.0305262308.6a4fc47b_at_posting.google.com>...
> I'm trying to create a composite hash subpartition on an existing
> range partitioned table
> According to the 9iR2 documentation I can do this with an alter table
> modify partition syntax kind of like :
>
> ALTER TABLE xxx MODIFY PARTITION yyy ADD SUBPARTITION zzz (COL1)
> SUBPARTITIONS 99
>
> - don't know where the BY HASH clase goes in above example
>
> The syntax is fine up to the add_hash_partition part of the doco, when
> I follow it to the subpartition_spec clause it only shows LIST
> example.
>
> Am I attempting the impossible ?
>
> David
Not possible. You add subpartition to a composite-potitioned table.
You can not change a simple partitioned table into a
composite-partitioned table this way. Easiest way is to create a new
composite-partitioned table and then insert into that new table select
from the old table.
Received on Tue May 27 2003 - 11:45:29 CDT
