Does anyone have an Example syntax of alter table modify partition subpartition by hash

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 Received on Tue May 27 2003 - 02:08:35 CDT