ORA-14071: invalid option for an index used to enforce a
constraint
- 1 Answers
- 4697 Views
- I also Faced
- E-Mail Answers
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 |
TNS-12602: TNS: Connection Pooling limit reached
ORA-08175: discrete transaction restriction violated (string)
ORA-06314: IPA: Event set up failure
ORA-28012: Manual commit not allowed here
ORA-23426: deferred RPC queue has entries for string
ORA-00152: current session does not match requested session
ORA-12476: least upper bound resulted in an invalid OS label
ORA-12566: TNS:protocol error
ORA-24775: cannot prepare or commit transaction with non-zero lock value
ORA-27216: skgfgsmcs: sbtinfo2 returned a malformed response
DRG-52101: an invalid session handle was passed to Oracle Text
NZE-29038: There are no matching certificates.
Oracle Errors 
