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

TNS-01301: TNS error structure:

1 Answers  


PCC-01018: Conversion buffer size can only be specified for character types

1 Answers  


NNL-00232: Auto-refresh failure-retry interval is currently string

1 Answers  


ORA-10641: Cannot find a rollback segment to bind to

1 Answers  


ORA-29917: cannot lock a table which gets its rows from a collection operand

1 Answers  






ORA-16636: the object is permanently disabled

1 Answers  


ORA-01191: file string is already offline - cannot do a normal offline

1 Answers  


ORA-36873: (XSTFDSC03) Column type must be specified explicitly.

1 Answers  


ORA-39029: worker string with process name "string" prematurely terminated

1 Answers  


TNS-01114: LSNRCTL could not perform local OS authentication with the listener

1 Answers  


TNS-12536: TNS:operation would block

1 Answers  


ORA-15094: attempted to write to file opened in read only mode

1 Answers  


Categories