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-06766: TLI Driver: close failed during release

1 Answers  


ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.

1 Answers  


ORA-22619: all collection elements have already been accessed

1 Answers  


RMAN-06547: tablespace SYSTEM cannot be excluded from whole database backup

1 Answers  


ORA-24003: Queue table index string inconsistent with queue table string

1 Answers  


DRG-10800: query failed: string string string

1 Answers  


ORA-38402: invalid name: empty string or spaces in the name

1 Answers  


KUP-04030: invalid numeric data

1 Answers  


ORA-01157: cannot identify/lock data file string - see DBWR trace file

1 Answers  


ORA-22280: no more buffers available for operation

1 Answers  


ORA-39049: invalid parameter name string

1 Answers  


ORA-01493: invalid SAMPLE size specified

1 Answers  


Categories