oracle組合分割槽系列三(composite list partition)

   前幾文:http://space.itpub.net/9240380/viewspace-752465及
              http://space.itpub.net/9240380/viewspace-752471測試了組合範圍及列

表分割槽的知識要點,承沿之前系列,測試列表組合分割槽

---範圍子分割槽
SQL> create table t_list(a int,b int)
  2  partition by list(a)
  3  subpartition by range(b)
  4  subpartition template
  5  (
  6   subpartition sub1 values less than(5),
  7   subpartition sub2 values less than(10)
  8   )
  9  (
 10   partition p1 values(1,2,3,4,5),
 11   partition p2 values(6,7,8,9,10)
 12  )
 13  /
 
Table created         
  
         
---列表子分割槽
SQL> create table t_list(a int,b int)
  2  partition by list(a)
  3  subpartition by list(b)
  4  subpartition template
  5  (
  6   subpartition sub1 values(1,2),
  7   subpartition sub2 values(3,4)
  8   )
  9  (
 10   partition p1 values(1,2,3,4,5),
 11   partition p2 values(6,7,8,9,10)
 12  )
 13  /
 
Table created   

---雜湊子分割槽方法一
SQL> create table t_list(a int,b int)
  2  partition by list(a)
  3  subpartition by hash(b)
  4  subpartition template
  5  (
  6   subpartition sub1,
  7   subpartition sub2
  8   )
  9  (
 10   partition p1 values(1,2,3,4,5),
 11   partition p2 values(6,7,8,9,10)
 12  )
 13  /
 
Table created  

---雜湊子分割槽方法二
SQL> create table t_list(a int,b int)
  2  partition by list(a)
  3  subpartition by hash(b)
  4    subpartitions 2
  5  (
  6   partition p1 values(1,2,3,4,5),
  7   partition p2 values(6,7,8,9,10)
  8  )
  9  /
 
Table created