Re: SPLIT partition and subpartition in one command

From: csn <>
Date: Mon, 25 Feb 2008 08:44:38 -0800 (PST)
Message-ID: <>

Just split the second partition (which is now the lowest):

alter table my_test split partition p2 at (to_date('01-FEB-2008','DD- -YYYY'))
into (partition p1 subpartitions 3, partition p2);

The subpartition clause is optional - if you don't specify it, it will default to whatever the value was when the table was first created. Received on Mon Feb 25 2008 - 10:44:38 CST

Original text of this message