Oracle 建立表分區

標籤：tab   資料   ace   ctf   rtti   date   mit   建立   tran   

create table TableName1
(
id CHAR(36) not null,
samplingdate TIMESTAMP(6) not null,
instantaneousflow NUMBER(10,3),
totalflow NUMBER(10),
flowmeterid CHAR(36) not null,
receivetime TIMESTAMP(6),
inserttime TIMESTAMP(6)
);
partition by range (SAMPLINGDATE)
INTERVAL ( NUMTOYMINTERVAL (1, ‘YEAR‘) ) --Oracle 11g支援 , Oracle會根據資料自動按照年份建立分區
(
partition P2012 values less than (TIMESTAMP‘ 2012-01-01 00:00:00‘)
tablespace WIMS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
);

Oracle 建立表分區