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

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


Cause:


Both REVERSE and NOREVERSE were specified in CREATE INDEX statement.



Action:


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