Hi,
I am using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.
Can anyone guide me how to create a subpartition (HASH) on an existing RANGE partitioned table or some examples?
I understand in Oracle 11G, we can do a Composite Range-Hash Partitioning.
I have shared below for only one partition, but the table has more partitions. Should I modify all the partitions in the table for adding the subpartition based on TRANS_ID column?
CREATE TABLE MASTER_VALUE
(
VALUE_DATE DATE NOT NULL,
TRANS_ID NUMBER NOT NULL,
TRANSFER_AMT NUMBER,
RECEIEVED_AMT NUMBER DEFAULT -1,
BOOK_ID NUMBER DEFAULT -1,
)
PARTITION BY RANGE (VALUE_DATE)
(
PARTITION RV_R_20141230 VALUES LESS THAN (TO_DATE(' 2014-12-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
)
Thanks