Oracle Error ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified

Oracle Error Message

ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified

Reason for the Error

PARALLEL was specified more than once, NOPARALLEL was specified more than once, or both PARALLEL and NOPARALLEL were specified in an ALTER INDEX REBUILD statement.

Solution

Remove all but one of the PARALLEL or NOPARALLEL clauses.