Creating interval parition to existing range partition
841883Apr 23 2013 — edited Apr 23 2013I have a table which has range partition on a number column.
CREATE TABLE TEST(
id INT NOT NULL,
start INT NOT NULL
)
PARTITION BY RANGE (start)
(
PARTITION old_Data VALUES LESS THAN (1000000) TABLESPACE old,
PARTITION new_Data VALUES LESS THAN (MAXVALUE) TABLESPACE new
);
I would like to create monthly interval partition in old_data partition. Is this possible? Don't see any syntax for supporting this scenario.