Create Table wzw_sales
(
Acct_no number (5 ),
Person varchar2 (30 ),
Sales_amount number (8 ),
Week_no number (2)
)
Partition by range (week_no)
Subpartition by list (acct_no)
(
Partition part9 values less than (9)
Tablespace dw_cdr_data
Pctfree 10
Pctused 40
Initrans 1
Maxtrans 255
(
Subpartition part9 values (1001) tablespace dw_cdr_data,
Subpartition sub2_part9 values (1002) tablespace dw_cdr_data
),
Partition part11 values less than (11)
Tablespace dw_cdr_data
Pctfree 10
Pctused 40
Initrans 1
Maxtrans 255
(
Subpartition part11 values (2001) tablespace dw_cdr_data,
Subpartition sub2_part11 values (2002) tablespace dw_cdr_data
)
);
Select * From wzw_sales partition (part9 );
Select * From wzw_sales subpartition (subpartition part9 );
Insert into wzw_sales values (1001, 'person1', 8 );
Insert into wzw_sales values (1002, 'person2', 2845,7 );
Insert into wzw_sales values (2001, 'person3', 3645,9 );
Insert into wzw_sales values (2002, 'person4', 4945,10 );
Grant create any table to dw;