ORA-12097: changes in the master tables during refresh, try
refresh again



ORA-12097: changes in the master tables during refresh, try refresh again..

Answer / guest

Cause: There are some changes (i.e., conventional DML,
direct load, partition maintenance operation) in the master
tables during materialized view refresh.

Action: Refresh the affected materialized views again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28603: statement not permitted on empty tables

1 Answers  


ORA-33450: (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.

1 Answers  


ORA-06140: NETTCP: no such user

1 Answers  


ORA-06130: NETTCP: host access denied

1 Answers  


ORA-16543: invalid request made to broker

1 Answers  






ORA-02803: Retrieval of current time failed

1 Answers  


what is error treshold?

1 Answers  


ORA-29914: ODCIGETINTERFACES routine does not return required stream version

1 Answers  


SQL*Loader-00283: file processing string "string" ignored for INFILE *

1 Answers  


ORA-32609: missing REFERENCE keyword in MODEL clause

1 Answers  


ORA-08006: specified row no longer exists

1 Answers  


EXP-00089: invalid FILE_FORMAT specification

1 Answers  


Categories