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-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.

1 Answers  


ORA-07800: slbtpd: invalid number

1 Answers  


LPX-00006: invalid child type for parent node

1 Answers  


NZE-29020: The handshake record length is too long.

1 Answers  


RMAN-06378: List of Backup Sets

1 Answers  






PCB-00557: USING clause can only be used on a PREPAREd dynamic statement

1 Answers  


NNL-00341: Trace file name is now string

1 Answers  


ORA-31462: internal error while accessing metadata

1 Answers  


ORA-12508: TNS:listener could not resolve the COMMAND given

1 Answers  


RMAN-05005: point-in-time recovery is not allowed for re-created tablespace string

1 Answers  


ORA-16133: Datafile string has incorrect terminal recovery stamp.

1 Answers  


NZE-28884: invalid cipher suite

1 Answers  


Categories