Oracle Error ORA-12819: missing options in PARALLEL clause

Oracle Error Message

ORA-12819: missing options in PARALLEL clause

Reason for the Error

PARALLEL clause cannot be empty.

Solution

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