create table tq84_tab ( dt date, id integer, nm number, tx varchar2(10) ) partition by range (dt) interval (numtoyminterval(1, 'MONTH')) (partition p_1 values less than (date '2020-01-01')) ; insert into tq84_tab values (null, 42, 123.45, 'xxx');
Index