上篇文章oracle hash partition哈希分区(一):http://space.itpub.net/9240380/viewspace-752264;
主要测试hash partition的创建语法;
oracle对于不同的分区类型会有不同的操作限制;
先摘录官方文档引语:
主要测试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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-752268/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-752268/