Oracle Error ORA-12051: ON COMMIT attribute is incompatible with other options

Oracle Error Message

ORA-12051: ON COMMIT attribute is incompatible with other options

Reason for the Error

ON COMMIT refresh attribute, incompatible with other refresh options such as automatic periodic refresh, was specified.

Solution

Specify only valid options.