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 /

索引已创建。

ITPub博客

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

最新文章