当前位置：首页 -> AI编程基础 -> 数据库编程

oracle超大数据库表分区只复合分区表（范围散列分区表）(二)

2014-11-24 15:17:58 · 作者: · 浏览: 3
标签: oracle 超大 数据库 分区 复合 分区表 范围
229 26
511611 240 60
511616 244 59
511603 229 26
511611 240 60
511616 244 59
511604 228 77
511606 228
511607 240 90
511613 244 88
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511604 228 77
511606 228
511607 240 90
511613 244 88
511601 229 92
511608 240 100
511610 240 75
511617 244 95
511601 229 92
511608 240 100
511610 240 75
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511617 244 95
34 rows selected.
SQL> select * from graderecord04 partition(p1);
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511602 229 62
511605 228 47
511609 240 67
511612 244 72
511614 244 19
511615 244 65
511602 229 62
511605 228 47
511609 240 67
511612 244 72
511614 244 19
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511615 244 65
511603 229 26
511611 240 60
511616 244 59
511603 229 26
511611 240 60
511616 244 59
18 rows selected.
SQL> select * from graderecord04 partition(p2);
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511604 228 77
511606 228
511607 240 90
511613 244 88
511604 228 77
511606 228
511607 240 90
511613 244 88
511601 229 92
511608 240 100
511610 240 75
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511617 244 95
511601 229 92
511608 240 100
511610 240 75
511617 244 95
16 rows selected.
SQL> select * from graderecord04 subpartition(sp1);
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511602 229 62
511605 228 47
511609 240 67
511612 244 72
511614 244 19
511615 244 65
511602 229 62
511605 228 47
511609 240 67
511612 244 72
511614 244 19
SNO SNAME DOR GRADE
---------- -------------------- --- ----------
511615 244 65
12 rows selected.
SQL> select * fr