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

ORA-27063: number of bytes read/written is incorrect

1 Answers  


ORA-10617: Cannot create rollback segment in dictionary managed tablespace

1 Answers  


ORA-12087: online redefinition not allowed on tables owned by "string"

1 Answers  


ORA-37023: (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.

1 Answers  


PCC-02035: CMD-LINE: CONFIG= option is invalid in a config file

1 Answers  






DRG-52100: %(1)s returned internal error code string

1 Answers  


ORA-08207: ora_addr: cannot open address file

1 Answers  


ORA-33456: (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.

1 Answers  


ORA-27087: unable to get share lock - file not readable

1 Answers  


ORA-19712: table name exceeds maximum length of string

1 Answers  


LRM-00120: 'string' is not a legal Oracle number for 'string'

1 Answers  


RMAN-08086: replaced script string

1 Answers  


Categories