adding new hash partition - oracle8i

hi,
when adding a new partition to a hash partitioned table, can you only add one new partition at a time? i have a hash partitioned table that split into 4 pieces and would like to increase it to 8. under oracle8i, it seems like i have to add each new partition as a separate ddl statement. ie -> alter table hash_table add partition new_partition5;

what i want to be able to do is -> alter table hash_table add partition new_partition5, new_partition6, new_partition7, new_partition8;

thanks in advance.
-maurice
samuels_at_seas.upenn.edu Received on Mon Nov 29 2004 - 15:31:26 CST