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

PLS-00395: wrong number of values in VALUES clause of INSERT statement

1 Answers  


ORA-09835: addCallback: callback port is already in a set.

1 Answers  


PLS-01421: FOR UPDATE clause

1 Answers  


ORA-35756: (VCTODT02) 'number' is not a valid date because number is out of range for a year.

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  






TNS-00259: Disabled Interchange list:

1 Answers  


ORA-32310: object materialized views must select from an object table

1 Answers  


ORA-00200: controlfile could not be created

1 Answers  


ORA-12839: cannot modify an object in parallel after modifying it

1 Answers  


ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.

1 Answers  


ORA-02828: Segment free list is empty

1 Answers  


ORA-22933: cannot change object with type or table dependents

1 Answers  


Categories