Oracle Error Message
ORA-02158: invalid CREATE INDEX option
Reason for the Error
An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified.
Solution
Choose one of the valid CREATE INDEX options.