建表:
create table YCDATA200806
(
FAC_NO NUMBER default 0 not null,
DEVTYPE_NO NUMBER default 0 not null,
DEV_NO NUMBER default 0 not null,
DOT_NO NUMBER default 0 not null,
REAL_TYPE NUMBER not null,
SAVETIME DATE not null,
SAVEVAL FLOAT default 0,
LOCAL_TIME DATE
)
PARTITION BY RANGE (SAVETIME)
(PARTITION YCDATA_CS1
VALUES LESS THAN (TO_DATE('2008-06-15 23:59:59','YYYY-MM-DD hh24:mi:ss') )
TABLESPACE DMSUSR,
PARTITION YCDATA_CS2
VALUES LESS THAN (TO_DATE('2008-06-30 23:59:59','YYYY-MM-DD hh24:mi:ss') )
TABLESPACE DMSUSR
);
建索引
create unique index pk_inYC on YCDATA200806 (FAC_NO, DEVTYPE_NO, DEV_NO, DOT_NO, REAL_TYPE, SAVETIME)
local
(
PARTITION YCDATA_CS1 TABLESPACE DMSUSR,
PARTITION YCDATA_CS2 TABLESPACE DMSUSR
);
或
create unique index pk_inYC on YCDATA200806 (FAC_NO, DEVTYPE_NO, DEV_NO, DOT_NO, REAL_TYPE, SAVETIME)
tablespace DMSUSR local ;