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_NO, DEALER_ID)
using index local
tablespace DCS_index
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
注:分区键不为主键的值是不能创建本地索引,只能创建全局索引的。