解决方案 »
- ORACLE ODI 是什么啊? 这个要怎么学啊?小弟第一天上班。。
- 在线等 存储过程测试 附值后为null 不盛感激
- 在Ubuntu10.10上安装oracle10.2时候碰到了问题
- <救命>oracle做了update的误操作,怎么恢复之前数据
- 存储过程动态Sql效率问题?
- 一个关于GTANT的问题,在线等.!!!!!!!!!!!11
- 分享:数据库从入门到精通的视频学习资料
- 请教一个SQL统计语句
- 两条 sql 语句的区别? 跪求大侠帮忙
- 如何从归档日志中恢复某张表的数据?
- home/oracle/app/oradata/orcl/下的文件是什么文件,可以删除吗?
- PROJECT BUILDER是ORACLE DEVELOPER的一个组件吧,那么ORACLE DEVELOPER是不是现在的FORMS AND REPORTS
LIST 分区--> VALUES (10)
RANGE分区-->values less than (10)
2、分区语句 应该 as 语句之前create table T1
partition by range (deptno)(
partition p1 values less than (10),
partition p2 values less than (20),
partition p3 values less than (30),
partition p4 values less than (40)
)
as select * from scott.empcreate table T1
partition by list (deptno)(
partition p1 values(10),
partition p2 values(20),
partition p3 values(30),
partition p4 values(40)
)
as select * from scott.emp
见官方说明
If the selected table is partitioned, then you can choose whether the new table will be partitioned the same way,
partitioned differently, or not partitioned. Partitioning is not carried over to the new table. Specify any desired
partitioning as part of the CREATE TABLE statement before the AS subquery clause.
外面用list,里面用less than?--]用list分区
create table scott.test01
partition by list (deptno)(
partition p1 values (10),
partition p2 values (20),
partition p3 values (30),
partition p4 values (40)
)
as select * from scott.emp
--用range分区
create table scott.test02
partition by range (deptno)(
partition p1 values less than (10),
partition p2 values less than(20),
partition p3 values less than(30),
partition p4 values less than(40)
)
as select * from scott.emp