9208 create partitioned table

Database version - 9.2.0.8

Create Partitioned table which PARTITION BY RANGE (EOW_DATE column which is of data type date) and then SUBPARTITION BY HASH (store column of number datatype)

Below are the list of columns

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

DEPT                                      NOT NULL NUMBER(4)

CLASS                                     NOT NULL NUMBER(4)

SUBCLASS                                  NOT NULL NUMBER(4)

STORE                                     NOT NULL NUMBER(10)

WH                                        NOT NULL NUMBER(10)

HALF_NO                                   NOT NULL NUMBER(5)

MONTH_NO                                  NOT NULL NUMBER(2)

WEEK_NO                                   NOT NULL NUMBER(2)

CURRENCY_IND                              NOT NULL VARCHAR2(1)

EOW_DATE                                  NOT NULL DATE

OPN_STK_RETAIL                                     NUMBER(20,4)

OPN_STK_COST                                       NUMBER(20,4)

STOCK_ADJ_RETAIL                                   NUMBER(20,4)

STOCK_ADJ_COST                                     NUMBER(20,4)