oracle _hash partition,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