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



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

Answer / guest

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.

Action: Choose one of the valid index options.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30133: reserved for future use

1 Answers  


PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 Answers  


ORA-12423: invalid position specified

1 Answers  


ORA-26670: STREAMS option requires COMPATIBLE parameter to be string or higher

1 Answers  


ORA-13223: duplicate entry for string in SDO_GEOM_METADATA

1 Answers   Oracle,


ORA-16809: multiple warnings detected for the database

1 Answers  


ORA-31676: illegal value for number of workers, string

1 Answers  


ORA-16723: Setting AlternateLocation property conflicts with the log transport setting.

1 Answers  


SQL-02100: Out of memory (i.e., could not allocate)

1 Answers  


ORA-02841: Server died on start up

1 Answers  


ORA-16766: Physical apply service unexpectedly offline

1 Answers  


ORA-06571: Function string does not guarantee not to update database

1 Answers  


Categories