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-39136: cannot specify an SCN on a transportable job

1 Answers  


ORA-24161: name string does not exist in the name value pair list

1 Answers  


ORA-22900: the SELECT list item of THE subquery is not a collection type

1 Answers  


ORA-30486: invalid window aggregation group in the window specification

1 Answers  


ORA-01206: file is not part of this database - wrong database id

1 Answers  






SQL*Loader-00289: SQL string for column string occludes SQL string for column string.

1 Answers  


TNS-00533: Connection dissolved or not yet made

1 Answers  


ORA-16172: archive logs detected beyond Terminal End-Of-Redo

1 Answers  


ORA-16806: Supplemental logging is not turned on.

1 Answers  


ORA-00001: unique constraint (string.string) violated

1 Answers  


ORA-02796: Done request is not in correct state

1 Answers  


ORA-35282: (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])

1 Answers  


Categories