范围分区表按年份分区2015分区里面插入都是2014年记录
CREATE TABLE test03(
time DATE,
name VARCHAR2(20),
ID integer )
PARTITION BY RANGE(time)
( PARTITION part01 VALUES LESS THAN (TO_DATE('2015-01-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE test,
PARTITION part02 VALUES LESS THAN (TO_DATE('2016-01-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE test,
PARTITION part03 VALUES LESS THAN (TO_DATE('2017-01-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE test );
time DATE,
name VARCHAR2(20),
ID integer )
PARTITION BY RANGE(time)
( PARTITION part01 VALUES LESS THAN (TO_DATE('2015-01-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE test,
PARTITION part02 VALUES LESS THAN (TO_DATE('2016-01-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE test,
PARTITION part03 VALUES LESS THAN (TO_DATE('2017-01-1 00:00:00','yyyy-mm-dd hh24:mi:ss')) TABLESPACE test );