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
3001 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-39017: Worker request not supported when job is in string state.

1 Answers

TNS-01189: The listener could not authenticate the user

1 Answers

NZE-28831: no data unit format

1 Answers

IMG-00560: input format does not support page selection

1 Answers

TNS-00286: Max Connect Time (secs) : number

1 Answers

DRG-12438: document table release failed

1 Answers

ORA-09883: Two Task interface: oratab file does not exist

1 Answers

SQL*Loader-00440: Invalid table specified as scope of a REF

1 Answers

ORA-12920: database is already in force logging mode

1 Answers

ORA-12096: error in materialized view log on "string"."string"

1 Answers

ORA-31448: invalid value for change_source

1 Answers

TNS-01052: The command completed successfully

1 Answers

For more Oracle Errors Interview Questions Click Here