OraFAQ Forum: SQL & PL/SQL » split partition table

Home » SQL & PL/SQL » SQL & PL/SQL » split partition table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

split partition table [message #243555]

Thu, 07 June 2007 13:37

joau_hk
Messages: 4
Registered: May 2007

Junior Member

I have a partition table partition range by 2 columns (X, Y),
I need to split the partition, should the syntax be:

alter table ptable
split partition sptable
at ((200, 'XYZ'),
(400, 'ABC'))
into
( sptable1, sptable2)

Thanks.

Report message to a moderator

Re: split partition table [message #243558 is a reply to message #243555]

Thu, 07 June 2007 13:55

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

yes

ALTER TABLE mytab SPLIT PARTITION 
      part_1 at (100) INTO ( PARTITION
      p_part_1 ..., PARTITION part_1_p1 ...);

after that rebuild indexes.

ALTER INDEX index1 REBUILD PARTITION part_1_p1;
ALTER INDEX index2 REBUILD PARTITION part_1_p2;
ALTER INDEX index3 REBUILD PARTITION part_1_p3;
ALTER INDEX index4 REBUILD PARTITION part_1_p4;

[Updated on: Thu, 07 June 2007 13:58]

Report message to a moderator