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

QSM-00753: the specified value string is out of the acceptable range of string to string for parameter string

1 Answers  


NNO-00808: Error connecting to region database

1 Answers  


ORA-04006: START WITH cannot be less than MINVALUE

1 Answers  


ORA-23480: Column string is not a top-level column of "string"."string".

1 Answers  


ORA-31643: unable to close dump file "string"

1 Answers  


ORA-01546: tablespace contains active rollback segment 'string'

1 Answers  


PROC-00015: Failed to initialize the cluster registry successfully

1 Answers  


ORA-01621: cannot rename member of current log if database is open

1 Answers  


ORA-24087: Invalid database user string

1 Answers  


ORA-29548: Java system class reported: string

1 Answers  


ORA-38423: Attribute set created from an ADT may not be extended.

1 Answers  


ORA-12046: cannot use trusted constraints for refreshing remote MV

1 Answers  


Categories