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-13608: The task or object name string is invalid.

1 Answers  


IMG-00701: unable to set the properties of an empty image

1 Answers  


ORA-24787: remote cursors must be closed before a call completes

1 Answers  


RMAN-08505: output filename=string

1 Answers  


CLSR-00529: RACGONS: host and port number to be removed does not exist

1 Answers  






KUP-04091: little endian byte order mark found when big endian expected in string

1 Answers  


LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers  


ORA-17620: failed to register the network adapter with Oracle Disk Manager library: string

1 Answers  


ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported

1 Answers  


NNL-00553: Displays forwarding statistics

1 Answers  


PCC-00118: Use of host variable initialization not supported by ANSI SQL

1 Answers  


ORA-13218: max number of supported index tables reached for [string] index

1 Answers  


Categories