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-02511: Invalid data type

1 Answers  


IMG-00609: unable to read image stored in a BFILE

1 Answers  


ORA-13284: failure to copy geometry object for conversion in place

1 Answers  


IMG-00703: unable to read image data

1 Answers  


PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

1 Answers  






NNC-00429: invalid octet string literal "string"

1 Answers  


ORA-16145: archival for thread# string sequence# string in progress

1 Answers  


TNS-00515: Connect failed because target host or object does not exist

1 Answers  


ORA-16752: Resource guard could not mount standby

1 Answers  


ORA-25112: maximum number of BITMAP index columns is 30

1 Answers  


NZE-29161: software integrity self-test failure

1 Answers  


ORA-28046: Password change for SYS disallowed

1 Answers  


Categories