CREATE TABLE Z_M_IN
(
ID CHAR(22) NOT NULL PRIMARY KEY,
YLJG_CODE CHAR(10) NOT NULL,
YPID CHAR(13) NOT NULL,
YPPH VARCHAR2(50) NOT NULL,
VALIDATE1 DATE,
UNIT0 VARCHAR2(10) NOT NULL,
UNIT_MIN VARCHAR2(10) NOT NULL,
PACNUM NUMBER,
NUM NUMBER(2,2) NOT NULL,
IN_DATE DATE,
IN_FPH VARCHAR2(20),
MER_CODE CHAR(6)
) Partition by range(IN_DATE) subpartition by list(substr(YLJG_CODE,1,4))
(
partition sale_date1 values less than (to_date(to_char(sysdate,'yyyy')+'-01-01', 'yyyy-mm-dd ')) tablespace ts_Date1
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date2 values less than (to_date(to_char(sysdate,'yyyy')+'-02-01', 'yyyy-mm-dd ')) tablespace ts_Date2
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date3 values less than (to_date(to_char(sysdate,'yyyy')+'-03-01', 'yyyy-mm-dd ')) tablespace ts_Date3
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date4 values less than (to_date(to_char(sysdate,'yyyy')+'-04-01', 'yyyy-mm-dd ')) tablespace ts_Date4
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date5 values less than (to_date(to_char(sysdate,'yyyy')+'-05-01', 'yyyy-mm-dd ')) tablespace ts_Date5
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date6 values less than (to_date(to_char(sysdate,'yyyy')+'-06-01', 'yyyy-mm-dd ')) tablespace ts_Date6
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date7 values less than (to_date(to_char(sysdate,'yyyy')+'-07-01', 'yyyy-mm-dd ')) tablespace ts_Date7
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date8 values less than (to_date(to_char(sysdate,'yyyy')+'-08-01', 'yyyy-mm-dd ')) tablespace ts_Date8
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date9 values less than (to_date(to_char(sysdate,'yyyy')+'-09-01', 'yyyy-mm-dd ')) tablespace ts_Date9
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date10 values less than (to_date(to_char(sysdate,'yyyy')+'-10-01', 'yyyy-mm-dd ')) tablespace ts_Date10
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date11 values less than (to_date(to_char(sysdate,'yyyy')+'-11-01', 'yyyy-mm-dd ')) tablespace ts_Date11
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date12 values less than (to_date(to_char(sysdate,'yyyy')+'-12-01', 'yyyy-mm-dd ')) tablespace ts_Date12
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
)
);
按河北省各区市份分区 然后再按月份分区 怎么老提示错误
命令出错, 行: 16 列: 59
错误报告:
SQL 错误: ORA-00907: 缺失右括号
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
(
ID CHAR(22) NOT NULL PRIMARY KEY,
YLJG_CODE CHAR(10) NOT NULL,
YPID CHAR(13) NOT NULL,
YPPH VARCHAR2(50) NOT NULL,
VALIDATE1 DATE,
UNIT0 VARCHAR2(10) NOT NULL,
UNIT_MIN VARCHAR2(10) NOT NULL,
PACNUM NUMBER,
NUM NUMBER(2,2) NOT NULL,
IN_DATE DATE,
IN_FPH VARCHAR2(20),
MER_CODE CHAR(6)
) Partition by range(IN_DATE) subpartition by list(substr(YLJG_CODE,1,4))
(
partition sale_date1 values less than (to_date(to_char(sysdate,'yyyy')+'-01-01', 'yyyy-mm-dd ')) tablespace ts_Date1
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date2 values less than (to_date(to_char(sysdate,'yyyy')+'-02-01', 'yyyy-mm-dd ')) tablespace ts_Date2
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date3 values less than (to_date(to_char(sysdate,'yyyy')+'-03-01', 'yyyy-mm-dd ')) tablespace ts_Date3
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date4 values less than (to_date(to_char(sysdate,'yyyy')+'-04-01', 'yyyy-mm-dd ')) tablespace ts_Date4
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date5 values less than (to_date(to_char(sysdate,'yyyy')+'-05-01', 'yyyy-mm-dd ')) tablespace ts_Date5
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date6 values less than (to_date(to_char(sysdate,'yyyy')+'-06-01', 'yyyy-mm-dd ')) tablespace ts_Date6
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date7 values less than (to_date(to_char(sysdate,'yyyy')+'-07-01', 'yyyy-mm-dd ')) tablespace ts_Date7
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date8 values less than (to_date(to_char(sysdate,'yyyy')+'-08-01', 'yyyy-mm-dd ')) tablespace ts_Date8
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date9 values less than (to_date(to_char(sysdate,'yyyy')+'-09-01', 'yyyy-mm-dd ')) tablespace ts_Date9
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date10 values less than (to_date(to_char(sysdate,'yyyy')+'-10-01', 'yyyy-mm-dd ')) tablespace ts_Date10
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date11 values less than (to_date(to_char(sysdate,'yyyy')+'-11-01', 'yyyy-mm-dd ')) tablespace ts_Date11
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
),
partition sale_date12 values less than (to_date(to_char(sysdate,'yyyy')+'-12-01', 'yyyy-mm-dd ')) tablespace ts_Date12
(
subpartition s1 values('1300'),
subpartition s2 values('1301'),
subpartition s3 values('1302'),
subpartition s4 values('1303'),
subpartition s5 values('1304'),
subpartition s6 values('1305'),
subpartition s7 values('1306'),
subpartition s8 values('1307'),
subpartition s9 values('1308'),
subpartition s10 values('1309'),
subpartition s11 values('1310')
)
);
按河北省各区市份分区 然后再按月份分区 怎么老提示错误
命令出错, 行: 16 列: 59
错误报告:
SQL 错误: ORA-00907: 缺失右括号
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货