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

SQL*Loader-00952: Error calling once/data file initialization

1 Answers

ORA-01696: controlfile is not a clone controlfile

1 Answers

ORA-02294: cannot enable (string.string) - constraint changed during validation

1 Answers

ORA-08462: raw buffer contains invalid decimal data

1 Answers

ORA-02432: cannot enable primary key - primary key not defined for table

1 Answers

SQL*Loader-00408: Physical record stack overflow

1 Answers

NCR-04010: NCRR: Unable to contact Oracle Names Server

1 Answers

ORA-33338: (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.

1 Answers

DRG-50864: number assignment failed

1 Answers

ORA-29358: resource plan string does not exist

1 Answers

ORA-28173: certificate not provided by proxy

1 Answers

ORA-06420: NETCMN: SID lookup failure

1 Answers

For more Oracle Errors Interview Questions Click Here