oracle index partion,oracle分区partition及分区索引partition index(一)

SQL> create table t_partition(partion_id int,a int)

2  partition by range(partition_id)

3  (

4   partition p1 values less than (10) tablespace users

5   partition p2 values less than (20) tablespace users

6   partition p3 values less than (maxvalue) tablespace users

7  )

8  /

partition p2 values less than (20) tablespace users

*

第 5 行出现错误:

ORA-14020: 不能指定表分区的此物理属性

SQL> c/partition_id/partion_id/

2* partition by range(partion_id)

SQL> r

1  create table t_partition(partion_id int,a int)

2  partition by range(partion_id)

3  (

4   partition p1 values less than (10) tablespace users,

5   partition p2 values less than (20) tablespace users,

6   partition p3 values less than (maxvalue) tablespace users

7* )

表已创建。

SQL>

SQL> r

1  create index idx_t_partition on t_partition(partion_id)

2  local

3  (partition p1_idx1 tablespace users,

4   partition p1_idx2 tablespace user2

5* )

create index idx_t_partition on t_partition(partion_id)

*

第 1 行出现错误:

ORA-14024: LOCAL 索引的分区数必须等于基础表的分区数

SQL> create index idx_t_partition on t_partition(partion_id)

2  local

3  (partition p1_idx1 tablespace users,

4   partition p1_idx2 tablespace users,

5   partition p1_idx3 tablespace users

6  )

7  /

索引已创建。