create table db_agent.T_USER_STATISTICS (
u_id NUMBER(9) default NULL not null,
imei VARCHAR(64) not null,
platid NUMBER(6),
mnc CHAR(2) not null,
cityid CHAR(4) not null,
cnt NUMERIC default 0 not null,
time DATE default SYSDATE not null,
isNew CHAR(1) default '0' not null
constraint CKC_ISNEW_T_USER_S check (isNew between '0' and '1' and isNew in ('0','1')),
isMonth CHAR(1) default '0' not null
constraint CKC_ISMONTH_T_USER_S check (isMonth between '0' and '1' and isMonth in ('0','1')),
isYear CHAR(1) default '0' not null
constraint CKC_ISYEAR_T_USER_S check (isYear between '0' and '1' and isYear in ('0','1')),
isPay CHAR(1) default '0' not null,
constraint PK_T_USER_STATISTICS primary key (u_id)
)partition by range (to_days(time))
(
PARTITION p7 VALUES LESS THAN (to_days('2009-08-01')) ,
PARTITION p8 VALUES LESS THAN (to_days('2009-09-01')) ,
PARTITION p9 VALUES LESS THAN (to_days('2009-10-01')) ,
PARTITION p10 VALUES LESS THAN (to_days('2009-11-01')) ,
PARTITION p11 VALUES LESS THAN (to_days('2009-12-01')) ,
PARTITION p12 VALUES LESS THAN (to_days('2010-01-01')) ,
PARTITION p13 VALUES LESS THAN (to_days('2010-02-01')) ,
PARTITION p14 VALUES LESS THAN (to_days('2010-03-01')) ,
PARTITION p15 VALUES LESS THAN (to_days('2010-04-01')) ,
PARTITION p16 VALUES LESS THAN (to_days('2010-05-01')) ,
PARTITION p17 VALUES LESS THAN (to_days('2010-06-01')) ,
PARTITION p18 VALUES LESS THAN (to_days('2010-07-01')) ,
PARTITION p19 VALUES LESS THAN (to_days('2010-08-01')) ,
PARTITION p20 VALUES LESS THAN (to_days('2010-09-01')) ,
PARTITION p21 VALUES LESS THAN (to_days('2010-10-01')) ,
PARTITION p22 VALUES LESS THAN (to_days('2010-11-01')) ,
PARTITION p23 VALUES LESS THAN (to_days('2010-12-01')) ,
PARTITION p48 VALUES LESS THAN MAXVALUE )
tablespace db_agent
/这样做是按月做的表分区吧??
u_id NUMBER(9) default NULL not null,
imei VARCHAR(64) not null,
platid NUMBER(6),
mnc CHAR(2) not null,
cityid CHAR(4) not null,
cnt NUMERIC default 0 not null,
time DATE default SYSDATE not null,
isNew CHAR(1) default '0' not null
constraint CKC_ISNEW_T_USER_S check (isNew between '0' and '1' and isNew in ('0','1')),
isMonth CHAR(1) default '0' not null
constraint CKC_ISMONTH_T_USER_S check (isMonth between '0' and '1' and isMonth in ('0','1')),
isYear CHAR(1) default '0' not null
constraint CKC_ISYEAR_T_USER_S check (isYear between '0' and '1' and isYear in ('0','1')),
isPay CHAR(1) default '0' not null,
constraint PK_T_USER_STATISTICS primary key (u_id)
)partition by range (to_days(time))
(
PARTITION p7 VALUES LESS THAN (to_days('2009-08-01')) ,
PARTITION p8 VALUES LESS THAN (to_days('2009-09-01')) ,
PARTITION p9 VALUES LESS THAN (to_days('2009-10-01')) ,
PARTITION p10 VALUES LESS THAN (to_days('2009-11-01')) ,
PARTITION p11 VALUES LESS THAN (to_days('2009-12-01')) ,
PARTITION p12 VALUES LESS THAN (to_days('2010-01-01')) ,
PARTITION p13 VALUES LESS THAN (to_days('2010-02-01')) ,
PARTITION p14 VALUES LESS THAN (to_days('2010-03-01')) ,
PARTITION p15 VALUES LESS THAN (to_days('2010-04-01')) ,
PARTITION p16 VALUES LESS THAN (to_days('2010-05-01')) ,
PARTITION p17 VALUES LESS THAN (to_days('2010-06-01')) ,
PARTITION p18 VALUES LESS THAN (to_days('2010-07-01')) ,
PARTITION p19 VALUES LESS THAN (to_days('2010-08-01')) ,
PARTITION p20 VALUES LESS THAN (to_days('2010-09-01')) ,
PARTITION p21 VALUES LESS THAN (to_days('2010-10-01')) ,
PARTITION p22 VALUES LESS THAN (to_days('2010-11-01')) ,
PARTITION p23 VALUES LESS THAN (to_days('2010-12-01')) ,
PARTITION p48 VALUES LESS THAN MAXVALUE )
tablespace db_agent
/这样做是按月做的表分区吧??
解决方案 »
- 用JDBC更新oracle数据库中的数据异常
- 20分 一个简单问题。
- OEM console 中在哪配置XML Database
- oracle怎样把查询结果导入到文本中呢,linux系统为例
- 这个过程为什么不能建
- Oracle 分组困扰求救
- 新手,问两个简单的问题,关于sql
- 新手笨问题:我在sql plus用“打开”来打开一个SQL文件,是不是就自动执行了这个sql脚本?
- 关于CONSTRAINT的数据字典
- 请教:我想在asp中使用本机oracle数据库,如何配置服务名,我的为什么不行,
- create session权限与connection权限有什么不同啊
- 求助:关于oracle的一个小问题
partition by range (time)
(
PARTITION p7 VALUES LESS THAN (to_date('2009-08-01','yyyy-mm-dd'))
.....
partition by range (字段名)
-----------
默认值为null 字段又设置为not null