oracle hash partition雜湊分割槽(二)_操作限制

  上篇文章oracle hash partition雜湊分割槽(一):http://space.itpub.net/9240380/viewspace-752264;
主要測試hash partition的建立語法;
  oracle對於不同的分割槽型別會有不同的操作限制;
  先摘錄官方文件引語:

  You cannot specify more than 16 partitioning key columns.--分割槽列不能超過16個
 

  Partitioning key columns must be of type CHAR, NCHAR, VARCHAR2, NVARCHAR2, VARCHAR, NUMBER,
  FLOAT, DATE, TIMESTAMP, TIMESTAMP WITH LOCAL TIMEZONE, or RAW.
  --分割槽列型別僅為如上列出的型別
 
測試:
SQL> create table t_hash_partition(a1 int,              
  2  a2 int,                                            
  3  a3 int,                                          
  4  a4 int,                                          
  5  a5 int,                                          
  6  a6 int,                                          
  7  a7 int,                                          
  8  a8 int,                                          
  9  a9 int,                                          
 10  a10 int,                                         
 11  a11 int,                                         
 12  a12 int,                                         
 13  a13 int,                                         
 14  a14 int,                                         
 15  a15 int,                                         
 16  a16 int,                                         
 17  a17 int                                          
 18  )                                                
 19  partition by hash(a1,                            
 20  a2,                                              
 21  a3,                                              
 22  a4,                                              
 23  a5,                                              
 24  a6,                                              
 25  a7,                                              
 26  a8,                                              
 27  a9,                                              
 28  a10,                                             
 29  a11,                                             
 30  a12,                                             
 31  a13,                                             
 32  a14,                                             
 33  a15,                                             
 34  a16,                                             
 35  a17                                              
 36  )                                                
 37  partitions 2                                     
 38  /                                                
a17                                                   
*                                                     
ERROR at line 35:                                     
ORA-14014: maximum number of partitioning columns is 16   

SQL> create table t_hash_partition(a clob,b int)            
  2  partition by hash(a)                                   
  3  partitions 2;                                          
partition by hash(a)                                        
                  *                                         
ERROR at line 2:                                            
ORA-14135: a LOB column cannot serve as a partitioning column