Oracle Error ORA-36393: (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.

Oracle Error Message

ORA-36393: (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.

Reason for the Error

The user didn’t use the ALL keyword when using CHANGES or CACHE.

Solution

Specify the ALL keyword.