Interval partitioning automatically creates new partitions when data exceeds the defined range, eliminating the need to manually add partitions. GBase 8s inherits this capability and extends it with concurrent storage distribution, NULL handling, and automated history cleanup — a complete partition management toolkit for a gbase database.

What Is Interval Partitioning?

A table starts with an initial range partition. From there, the database automatically creates new partitions at a fixed interval — for example, one per month or per million rows. Both Oracle and GBase 8s support this pattern with similar syntax.

-- Oracle syntax CREATE TABLE orders ( order_num NUMBER NOT NULL , order_date DATE ) PARTITION BY RANGE ( order_date ) INTERVAL ( NUMTODSINTERVAL ( 1 , 'MONTH' )) ( PARTITION p1 VALUES LESS THAN ( TO_DATE ( '2024-02-01' , 'YYYY-MM-DD' )) );

-- GBase 8s syntax CREATE TABLE orders ( order_num INTEGER NOT NULL , order_date DATE ) FRAGMENT BY RANGE ( order_date ) INTERVAL ( NUMTOYMINTERVAL ( 1 ,…