Oracle Error ORA-12822: duplicate option in PARALLEL clause

Oracle Error Message

ORA-12822: duplicate option in PARALLEL clause

Reason for the Error

DEGREE or INSTANCES was specified more than once within a PARALLEL clause.

Solution

specify each desired PARALLEL clause option only once.