Oracle Solution for Error ora-36394

ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object

, CACHE is the only valid directive.

What triggered the Error:

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

What should we do to fix it:

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