<!--按时间分区-->
create table interval_test_by_year
(
region number(4),
recdate date not null,
recoid number
)
partition by range(recdate)
interval(numtoyminterval(1,'year')) //天 numtodsinterval
(
partition p1 values less than(to_date('20130116','yyyymmdd'))
create table interval_test_by_year
(
region number(4),
recdate date not null,
recoid number
)
partition by range(recdate)
interval(numtoyminterval(1,'year')) //天 numtodsinterval
(
partition p1 values less than(to_date('20130116','yyyymmdd'))
);
<!--按条数分区----2000条一个区
create table interval_test_by_number
(
empno number(6),
name varchar2(20),
sal number(6)
)
partition by range(sal)
Interval (2000)
(
partition p_2k values less than (2001)
);