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

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

Question Posted / guest

1 Answers
3005 Views
I also Faced
E-Mail Answers

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-25442: too many column values for table alias: string

1 Answers

PLS-00494: coercion into multiple record targets not supported

1 Answers

ORA-36666: (XSDPART04) workspace object is not a concat dimension.

1 Answers

ORA-01878: specified field not found in datetime or interval

1 Answers

ORA-16732: Error executing dbms_logstdby.skip procedure

1 Answers

ORA-24027: AQ HTTP propagation encountered error, status-code string, string

1 Answers

ORA-07240: slemrd: seek error.

1 Answers

PLS-01401: Identifier over 18 characters long

1 Answers

ORA-26513: push error: master proc. string$RP.string failed for trans:string seq:string

1 Answers

NNL-00955: Hash tables enlarged: number

1 Answers

ORA-29890: specified primary operator does not have an index context

1 Answers

NNL-00418: Attributes Mapped: number

1 Answers

For more Oracle Errors Interview Questions Click Here