"Extending" partitioned tables

From: Charlie Mengler <charliem_at_mwh.com>
Date: Wed, 03 May 2000 10:06:06 -0700
Message-Id: <10486.104827@fatcity.com>

If I were to pre-create today a partitioned table using the SQL below

create table sales_summary
as select * from sales_summary_at_edwdev
where 1 = 2
partition by range (SALES_DATE)
(partition SS_2000Q1 values less than to_date('01-APR-2000','DD-MON-YYYY') tablespace SS_2000Q1,

 partition SS_2000Q2  values less than to_date('01-JUL-2000','DD-MON-YYYY') tablespace SS_2000Q2,
 partition SS_2000Q3  values less than to_date('01-JUL-2000','DD-MON-YYYY') tablespace SS_2000Q3,
 partition SS_2000Q4  values less than to_date('01-JAN-2001','DD-MON-YYYY') tablespace SS_2000Q4,

)
/

(Assume that the four 2001 tablespaces are created independently.)
Would the following SQL allow me to "extend" the existing partitioned table made with the SQL above? If not, what SQL would be the needed next year to handle 2001 data in a similar manner?  

create table sales_summary
as select * from sales_summary_at_edwdev
where 1 = 2
partition by range (SALES_DATE)
(partition SS_2001Q1 values less than to_date('01-APR-2001','DD-MON-YYYY') tablespace SS_2001Q1,

 partition SS_2001Q2  values less than to_date('01-JUL-2001','DD-MON-YYYY') tablespace SS_2001Q2,
 partition SS_2001Q3  values less than to_date('01-JUL-2001','DD-MON-YYYY') tablespace SS_2001Q3,
 partition SS_2001Q4  values less than to_date('01-JAN-2002','DD-MON-YYYY') tablespace SS_2001Q4,

)
/

-- 
Charlie Mengler                       Maintenance Warehouse  
charliem_at_mwh.com                      5505 Morehouse Drive   
858-552-6229                          San Diego, CA 92121    
If you don't use vi, then you shouldn't be working on UNIX!

Received on Wed May 03 2000 - 12:06:06 CDT