Oracle partition creation tutorial, oracle partition tutorial
Before 11g, You need to manually maintain the partition. After 11 GB, interval is used to implement automatic expansion of partitions, which simplifies maintenance.
By YEAR: INTERVAL (NUMTOYMINTERVAL (1, 'Year '))
By MONTH: INTERVAL (NUMTOYMINTERVAL (1, 'month '))
By DAY: INTERVAL (NUMTODSINTERVAL (1, 'day '))
By time, MINUTE, and SECOND: NUMTODSINTERVAL (n, {'day' | 'hour' | 'minute '| 'second '})
Create table t_test (pk_id number (30) not null primary key, username VARCHAR2 (32), RELEASE_TIME DATE) partition by range (RELEASE_TIME) interval (numtoyminterval (1, 'Year ')) (partition p_year_1 values less than (to_date ('1970-01-01 ', 'yyyy-mm-dd ')));
Details about other oracle partitions:
Oracle table partitions are divided into four types: range partitions, hash partitions, list partitions, and composite partitions.
Fsd