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

ORA-23309: object string.string of type string exists

1 Answers  


DRG-13104: indexes do not have equivalent settings for string

1 Answers  


UDE-00012: table mode exports only allow objects from one schema

1 Answers  


PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression

1 Answers  


QSM-01098: mv string clause more restrictive than query string clause

1 Answers  






ORA-01252: cannot prevent writes - file string in recovery manager backup

1 Answers  


ORA-32406: cannot alter partitioning for existing materialized view log

1 Answers  


ORA-06521: PL/SQL: Error mapping function

1 Answers  


PLS-00420: can't call builtin routines remotely

1 Answers  


ORA-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


ORA-38410: schema extension not allowed for the table name

1 Answers  


TNS-12611: TNS:operation is not portable

1 Answers  


Categories