How to fix the Oracle error ORA-36393: (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.?

In this post, you’ll learn more about the Oracle ErrorORA-36393: (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

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

You can fix this error in Oracle by following the below steps

Specify the ALL keyword.