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

NZE-29245: the toolkit does not recognize the function being used

1 Answers  


ORA-22866: default character set is of varying width

1 Answers  


ORA-32338: on commit refresh grab all the detailed tables

1 Answers  


ORA-00981: cannot mix table and system auditing options

1 Answers  


SQL-02151: Invalid host variable for exact numeric SET statement item

1 Answers  






LSX-00023: unknown namespace URI "~S"

1 Answers  


DRG-10315: logging is not supported on MTS

1 Answers  


SQL*Loader-00128: unable to begin a session

1 Answers  


ORA-30106: reserved for future use

1 Answers  


NID-00415: Change of database name and database ID failed.

1 Answers  


ORA-38705: Expected block size string does not match string in log header.

1 Answers  


RMAN-03003: command not implemented yet: string

1 Answers  


Categories