oracle分区
Snowballl
数据库攻城师
展开
-
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
SQL> alter table tmp2 2 add constraint PK_tmp2 primary key (SO_NO, DEALER_ID) 3 using index local 4 tablespace DCS_index; alter table tmp2 add constraint PK_tmp2 primary key (SO_N原创 2013-11-13 09:15:25 · 3177 阅读 · 0 评论 -
创建哈希全局索引
alter table tmp2 add constraint PK_tmp2 primary key (SO_NO, DEALER_ID) using index global partition by hash(SO_NO, DEALER_ID) (PARTITION part_1, PARTITION part_2)tablespace DCS_index;原创 2013-11-13 09:18:54 · 852 阅读 · 0 评论 -
ORA-14038: GLOBAL partitioned index must be prefixed
1 创建分区表 create table tmp2( DEALER_ID NUMBER(8) not null, SO_NO CHAR(12) not null, SO_STATUS NUMBER(8) not null, COMPANY_ID NUMBER(8) not n原创 2013-11-13 10:29:26 · 1980 阅读 · 0 评论