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_NO, DEALER_ID)
using index local
tablespace DCS_index
 
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

 

 

注：分区键不为主键的值是不能创建本地索引，只能创建全局索引的。