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-19805: recid string of string is about to be deleted or resized

1 Answers  


ORA-01625: rollback segment 'string' does not belong to this instance

1 Answers  


ORA-06752: TLI: error in signal setup

1 Answers  


ORA-12233: TNS:Failure to accept a connection

1 Answers  


LSX-00255: mismatched parentheses

1 Answers  


ORA-15013: diskgroup "string" is already mounted

1 Answers  


ORA-26003: parallel load not supported for index-organized table string.

1 Answers  


ORA-16067: activation identifier mismatch in archive log string

1 Answers  


PLS-00453: remote operations not permitted on object tables or user-defined type columns

1 Answers  


ORA-25465: variable name not specified

1 Answers  


ORA-07657: slsprom:$ASSIGN failure

1 Answers  


ORA-23398: user name "string" at database link "string" does not match local user name "string"

1 Answers  


Categories