支持的,且语法兼容,例如范围分区:
create table t_range
(
id number PRIMARY KEY,
test_date date
)
partition by range
(
test_date
)
interval
(
numtoyMinterval (1, ‘MONTH’)
)
(
partition p_2014_01_01 values less than (to_date(‘2022-06-01’, ‘yyyy-mm-dd’))
);
详见官方SQL手册“定义水平分区表”
支持的,且语法兼容,例如范围分区:
create table t_range
(
id number PRIMARY KEY,
test_date date
)
partition by range
(
test_date
)
interval
(
numtoyMinterval (1, ‘MONTH’)
)
(
partition p_2014_01_01 values less than (to_date(‘2022-06-01’, ‘yyyy-mm-dd’))
);
详见官方SQL手册“定义水平分区表”