ORA-14071: invalid option for an index used to enforce a constraint

Hi ,

While enforcing the constraints for an index . "ORA-14071" error comes out as mentioned below ..

alter table esvc.ESVC_LGEIL_ITEM_AGEING
add constraint PK_ESVC_LGEIL_ITEM_AGEING primary key (INVENTORY_ITEM_ID, YYYYMM)
using index
tablespace ESVCD
pctfree 10
pctused 40
initrans 75
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
ERROR at line 6:
ORA-14071: invalid option for an index used to enforce a constraint


This eror is because the user has used "PCTUSED" in the above command and only
options COMPRESS, NOCOMPRESS, PCTFREE, INITRANS,MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE,
UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL are allowed with index used to enforce a constraint .

Since the user was using the "pctused 40" . Thus this error comes out . To get out of this error remove the "pctused 40" .
It will work for you ....