Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> adding new hash partition - oracle8i

adding new hash partition - oracle8i

From: <samuels_at_red.seas.upenn.edu>
Date: Mon, 29 Nov 2004 21:31:26 +0000 (UTC)
Message-ID: <cog4fe$a4nl$1@netnews.upenn.edu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US