Oracle Error ORA-12818: invalid option in PARALLEL clause

Oracle Error Message

ORA-12818: invalid option in PARALLEL clause

Reason for the Error

an unrecognized option was used within a PARALLEL clause.

Solution

specify any combination of DEGREE { | DEFAULT } and INSTANCES { | DEFAULT } within the PARALLEL clause.