Database DataWarehousing (MOSC)

MOSC Banner

partition table

edited Jul 22, 2010 7:10AM in Database DataWarehousing (MOSC) 10 commentsAnswered ✓
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center