create table g_emp(
empno number(4) primary key,
ename char(10),
job char(10),
mgr number(4),
hiredate date,
sale number(7,2),
comm number(3,2),
deptno number(8,3)
)
partition by range(sale)
(
partition p1 values less than(1000) tablespace tbs1,
partition p2 values less than(2000) tablespace tbs2,
partition p3 values less than(3000) tablespace tbs3,
partition p4 values less than(4000) tablespace tbs4,
partition p5 values less than(5000) tablespace tbs5,
partition p6 values less than(maxvalue) tablespace tbs6,
);
显示报错缺失pritition关键字,萌新求教!
empno number(4) primary key,
ename char(10),
job char(10),
mgr number(4),
hiredate date,
sale number(7,2),
comm number(3,2),
deptno number(8,3)
)
partition by range(sale)
(
partition p1 values less than(1000) tablespace tbs1,
partition p2 values less than(2000) tablespace tbs2,
partition p3 values less than(3000) tablespace tbs3,
partition p4 values less than(4000) tablespace tbs4,
partition p5 values less than(5000) tablespace tbs5,
partition p6 values less than(maxvalue) tablespace tbs6,
);
显示报错缺失pritition关键字,萌新求教!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货