Oracle Error ORA-12821: invalid value for INSTANCES

Oracle Error Message

ORA-12821: invalid value for INSTANCES

Reason for the Error

invalid value for INSTANCES was specified within a PARALLEL clause.

Solution

specify a positive integer or DEFAULT for the INSTANCES option within a PARALLEL clause.