ORA-02158: invalid CREATE INDEX option



ORA-02158: invalid CREATE INDEX option..

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.

Action: Choose one of the valid CREATE 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

TNS-12657: No algorithms installed

1 Answers  


PLS-00230: OUT and IN OUT formal parameters may not have default expressions

1 Answers  


ORA-19637: backupPieceCreate requires file name when using DISK device

1 Answers  


PROC-00018: The value size passed is too large

1 Answers  


ORA-12068: updatable mview log for mview "string"."string" does not exist

1 Answers  






ORA-16804: One or more configuration properties in metadata have invalid values.

1 Answers  


TNS-00031: INTCTL: internal NT error

1 Answers  


ORA-02198: ONLINE/OFFLINE option already specified

1 Answers  


O2U-00208: One or more characters in an attribute name were not legal identifier characters

1 Answers  


VID-00705: unsupported input format

1 Answers  


ORA-06129: NETTCP: unable to transfer socket ownership to ORASRV

1 Answers  


ORA-23471: template not authorized for user

1 Answers  


Categories