ORA-23472: materialized view "string"."string" must be
atomically refreshed



ORA-23472: materialized view "string"."string" must be atomically refreshed..

Answer / guest

Cause: Non-atomic refresh is not supported for the specified
materialized view.

Action: Set the value of the ATOMIC parameter to FALSE in
the refresh procedure being used or remove the specified
materialized view from the set of materialized views being
refreshed.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMG-00511: %s

1 Answers  


SQL*Loader-00710: Internal error: direct path stream buffer not loaded

1 Answers  


ORA-30381: REWRITE_TABLE is not compatible with Oracle version

1 Answers  


ORA-01543: tablespace 'string' already exists

1 Answers  


ORA-21705: service context is invalid

1 Answers  






DRG-11835: Requested Range Not Satisfiable

1 Answers  


CLSR-00006: Error encountered when writing file string

1 Answers  


NNL-00288: No cache flush currently scheduled

1 Answers  


ORA-01145: offline immediate disallowed unless media recovery enabled

1 Answers  


ORA-01190: controlfile or data file string is from before the last RESETLOGS

1 Answers  


DRG-10306: server terminated unexpectedly while processing command

1 Answers  


ORA-39954: DEFERRED is required for this system parameter

1 Answers  


Categories