alter table ZABBIX.TRENDS
  add primary key (ITEMID, CLOCK)
  using index 
  tablespace ZABBIX_SCHE_TRENDS_TBS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

alter table ZABBIX.TRENDS drop PRIMARY KEY;


SQL> alter table ZABBIX.TRENDS add CONSTRAINT PK_HISTORY_UINT  PRIMARY KEY(ITEMID, CLOCK, NS) using index local tablespace ZABBIX_SCHE_HISTORY_TBS;
alter table ZABBIX.TRENDS add CONSTRAINT PK_HISTORY_UINT    PRIMARY KEY(ITEMID, CLOCK, NS) using index local tablespace ZABBIX_SCHE_HISTORY_TBS
*
ERROR at line 1:
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE
index

需要将分区键加入到分区索引中
alter table ZABBIX.TRENDS add CONSTRAINT PK_TRENDS  PRIMARY KEY(ITEMID, CLOCK, UPD_TIME) using index local tablespace ZABBIX_SCHE_HISTORY_TBS;

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle