invalid option for an index used to enforce a constraint

Solution ID:ORA-14071

Type: Oracle

Cause

An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified for an index used to enforce a constraint.

Actions

Correct the code generating text of CREATE INDEX statement sent to the slaves

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/2123570


https://community.oracle.com/message/9229172


https://community.oracle.com/message/1900075


https://community.oracle.com/message/3117091


Browse all solutions to database errors from Oracle, MS SQL, or MySQL