Oracle Error ORA-14125: REVERSE/NOREVERSE may not be specified in this context

Oracle Error Message

ORA-14125: REVERSE/NOREVERSE may not be specified in this context

Reason for the Error

REVERSE/NOREVERSE clause is not allowed in this context.

Solution

Remove offending clause. REVERSE may be specified as an attribute of an index (not of an individual partition, if creating a partitioned index) in CREATE INDEX statement and ALTER INDEX REBUILD statement. NOREVERSE may be specified only in ALTER INDEX REBUILD statement.