partition table
Hi,
Created a partition table as follows
CREATE TABLE schl_test (ORDER_DATE date,ORDER_CODE VARCHAR2(12),ORDER_INTRNL_LINE_NUM number,SCHED_NUM number,UNIQUE_NUM number,LOAD_NUM number,TKT_CODE VARCHAR2(12))
PARTITION BY RANGE (order_date) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
SUBPARTITION BY HASH(order_code)
SUBPARTITION TEMPLATE(
SUBPARTITION sp1 TABLESPACE users,
SUBPARTITION sp2 TABLESPACE users,
SUBPARTITION sp3 TABLESPACE users,
SUBPARTITION sp4 TABLESPACE users)
(PARTITION old_data VALUES LESS THAN (To_Date('09/01/2009','mm/dd/yyyy')) TABLESPACE users,
PARTITION current_mon VALUES LESS THAN (To_Date('07/01/2010','mm/dd/yyyy')) TABLESPACE users
)
When I inserted data with order_date being 10/20/2009 it went into current_mon partition. Isn't that it is supposed to create a partition for the month of Oct 2009 and put the data in that partition?
CREATE TABLE schl_test (ORDER_DATE date,ORDER_CODE VARCHAR2(12),ORDER_INTRNL_LINE_NUM number,SCHED_NUM number,UNIQUE_NUM number,LOAD_NUM number,TKT_CODE VARCHAR2(12))
PARTITION BY RANGE (order_date) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
SUBPARTITION BY HASH(order_code)
SUBPARTITION TEMPLATE(
SUBPARTITION sp1 TABLESPACE users,
SUBPARTITION sp2 TABLESPACE users,
SUBPARTITION sp3 TABLESPACE users,
SUBPARTITION sp4 TABLESPACE users)
(PARTITION old_data VALUES LESS THAN (To_Date('09/01/2009','mm/dd/yyyy')) TABLESPACE users,
PARTITION current_mon VALUES LESS THAN (To_Date('07/01/2010','mm/dd/yyyy')) TABLESPACE users
)
When I inserted data with order_date being 10/20/2009 it went into current_mon partition. Isn't that it is supposed to create a partition for the month of Oct 2009 and put the data in that partition?
0