Oracle Error ORA-14122: only one REVERSE or NOREVERSE clause may be specified

Oracle Error Message

ORA-14122: only one REVERSE or NOREVERSE clause may be specified

Reason for the Error

Both REVERSE and NOREVERSE were specified in CREATE INDEX statement.

Solution

Remove all but one of the REVERSE or NOREVERSE clauses and reissue the statement.