oracle組合分割槽系列二(composite hash partition)

在上文:http://space.itpub.net/9240380/viewspace-752465,測試了組合範圍分割槽.
本文繼續學習組合雜湊分割槽的相關使用

---用子分割槽模板建立組合分割槽(模板:可理解為通用方法,一次建立多次使用)
---範圍子分割槽
SQL> create table t_hash(a int,b int)
  2  partition by hash(a)
  3  subpartition by range(b)
  4  subpartition template(
  5                        subpartition sub1 values less than (5),
  6                        subpartition sub2 values less than (10)
  7                       )
  8  (
  9   partition px1,
 10   partition px2
 11  )
 12  /
 
Table created

---列表子分割槽
SQL> create table t_hash(a int,b int)
  2  partition by hash(a)
  3  subpartition by list(b)
  4  subpartition template(
  5                        subpartition sub1 values (1,2,3,4,5),
  6                        subpartition sub2 values (6,7,8,9,10)
  7                       )
  8  (
  9   partition px1,
 10   partition px2
 11  )
 12  /
 
Table created

 

---雜湊子分割槽
SQL> create table t_hash(a int,b int)
  2  partition by hash(a)
  3  subpartition by hash(b)
  4  subpartition template(
  5                        subpartition sub1,
  6                        subpartition sub2
  7                       )
  8  (
  9   partition px1,
 10   partition px2
 11  )
 12  /
 
Table created