ORA-14071 error caused by COMPRESS clause in ADD CONSTRAINT USING INDEX
Hi !
I was exporting my DB schema using expdp in Oracle 10.2.0.1.0 (running on HP-UX 11.23) and I got an error during the impdp.
The error was related to this command:
ALTER TABLE "SMS"."SVCOBJ" ADD CONSTRAINT "UK_SO02" UNIQUE ("SVCNAME", "SOTNAME", "SOKEY", "PARENTSOID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SERVICEX" ENABLE
The same DB schema exported with exp included the following statement for the same constraint:
ALTER TABLE "SVCOBJ" ADD CONSTRAINT "UK_SO02" UNIQUE ("SVCNAME", "SOTNAME", "SOKEY", "PARENTSOID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 8388608 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT) TABLESPACE "SERVICEX" LOGGING ENABLE
The "COMPRESS 2" clause in the expdp dump was failing. Do you know why this is not allowed ? The oraerr descirption for 14071 includes the COMPRESS clause in the allowed list of parameters, and most of all this was created by expdp.
I tried to remove it and re-ran it manually and it went fine. Same thing happened for all the constraints using indexes compressed.
Thanks in advance !
Mike