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



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

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28115: policy with check option violation

1 Answers   Wipro,


ORA-37031: (XSMLTMAINT02) You cannot MOVE, DELETE, or add SESSION values of dimension workspace object in MULTI mode.

1 Answers  


PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC

1 Answers  


TNS-02511: Invalid data type

1 Answers  


LPX-00658: Invalid XSLT object type.

1 Answers  


ORA-27193: sbtinfo2 did not return volume label

1 Answers  


ORA-12495: cannot disable an enabled level, category, or release category

1 Answers  


ORA-19611: backup piece out of order. Expected string but found string

1 Answers  


QSM-02064: subquery in mv

1 Answers  


DRG-10501: invalid stopword: string

1 Answers  


SQL-02144: Invalid ANSI dynamic usage

1 Answers  


ORA-01509: specified name 'string' does not match actual 'string'

1 Answers  


Categories