Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

TNS-00105: Could not initialize tracing

1 Answers  


ORA-01570: MINEXTENTS must be no larger than the string extents currently allocated

1 Answers  


ORA-29823: object being analyzed is not a table

1 Answers  


LSX-00112: facet "~S" duplicated

1 Answers  


ORA-30374: materialized view is already fresh

1 Answers  






ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION

1 Answers  


ORA-31001: Invalid resource handle or path name "string"

1 Answers  


ORA-32736: Hang analysis aborted due to wrong message type

1 Answers  


ORA-14626: values being added already exist in DEFAULT subpartition

1 Answers  


ORA-01752: cannot delete from view without exactly one key-preserved table

1 Answers  


ORA-19861: additional backup pieces cannot be validated in this conversation

1 Answers  


RMAN-05503: at least one auxiliary channel must be allocated to execute this command

1 Answers  






Categories