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  /

索引已创建。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-751528/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-751528/