Re: SPLIT partition and subpartition in one command
From: csn <csn233_at_gmail.com>
Date: Mon, 25 Feb 2008 08:44:38 -0800 (PST)
Message-ID: <5ca5b837-c5b1-493a-82c9-25265f33e921@s37g2000prg.googlegroups.com>
Date: Mon, 25 Feb 2008 08:44:38 -0800 (PST)
Message-ID: <5ca5b837-c5b1-493a-82c9-25265f33e921@s37g2000prg.googlegroups.com>
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