Oracle Error ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.

Oracle Error Message

ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.

Reason for the Error

The user attempted to CLEAR an AGGMAP using a directive other than CACHE.

Solution

Amend the CLEAR line to only use the CACHE keyword with AGGMAPs.