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 /
索引已创建。