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-25298: The memory threshold for a queue cannot be negative

1 Answers  


ORA-02494: invalid or missing maximum file size in MAXSIZE clause

1 Answers  


DRG-10510: stopword is missing

1 Answers  


ORA-23409: could not find an unused refresh group number

1 Answers  


ORA-27052: unable to flush file data

1 Answers   Aomi,






ORA-38428: too many attributes selected for indexing

1 Answers  


PCC-01015: Cannot equivalence PIC N variable string

1 Answers  


ORA-39032: function string is not supported in string jobs

1 Answers  


TNS-00546: control failure

1 Answers  


TNS-00017: INTCTL: error while performing NS receive command

1 Answers  


RMAN-20204: translation not started

1 Answers  


ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

1 Answers  


Categories