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
2835 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

PLS-00311: the declaration of "string" is incomplete or malformed

2 Answers

NZE-28761: element creation failure

1 Answers

SQL*Loader-00563: bad length for VAR record

1 Answers

ORA-30507: normal triggers cannot be based on a schema or a database

1 Answers

NCR-02009: NCRF: Unable to open trace file

1 Answers

ORA-08450: invalid specification of CR in picture mask

1 Answers

EXP-00041: INCTYPE parameter is obsolete

1 Answers

ORA-03236: max # extents (string) reached in index string.string subpartition string

1 Answers

TNS-02510: Invalid numeric data type

1 Answers

ORA-12667: Shared server: outbound transport protocol different from inbound

1 Answers

ORA-19018: Invalid character in XML tag 'string'

1 Answers

ORA-02763: Unable to cancel at least one request

1 Answers

For more Oracle Errors Interview Questions Click Here