I have two tables TEST1 and TEST1_HIST. Test1 is partitioned on fin_prd_start_date and Test1_Hist is partitioned on bill month column.
Please let me know if there is any easy way to move the partition from TEST1 to TEST1_HIST with DDL Commands.
CREATE TABLE TEST1
(
F_SEQ_NO NUMBER,
FIN_START_DATE DATE ,
BILL_MONTH DATE
)
PARTITION BY RANGE (FIN_START_DATE)
INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(
PARTITION part_01 values LESS THAN (TO_DATE('01-JAN-2017','DD-MON-YYYY'))
);
CREATE TABLE TEST1_INTREM
(
F_SEQ_NO NUMBER,
FIN_START_DATE DATE ,
BILL_MONTH DATE
);
CREATE TABLE TEST1_HIST
(
F_SEQ_NO NUMBER,
FIN_START_DATE DATE ,
BILL_MONTH DATE
)
PARTITION BY RANGE (BILL_MONTH)
INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(
PARTITION part_01 values LESS THAN (TO_DATE('01-JAN-2017','DD-MON-YYYY'))
);