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-25152: TEMPFILE cannot be dropped at this time

1 Answers  


IMP-00035: input file string must be on a disk

1 Answers  


ORA-24355: attempt to store a negative number in an Unsigned Display type.

1 Answers  


ORA-31097: Hierarchical Index not empty

1 Answers  


TNS-04021: The SET command is unsuccessful for parameter string.

1 Answers  






TNS-00532: No previous async operation to wait on

1 Answers  


ORA-24351: invalid date passed into OCI call

1 Answers  


ORA-38765: Flashed back database cannot be opened read-only.

1 Answers  


PLS-00352: Unable to access another database 'string'

1 Answers  


ORA-23425: invalid materialized view identifier string

1 Answers  


DRG-52105: no delete function found

1 Answers  


ORA-38607: FI minimum and maximum itemset length not between [1, string]

1 Answers  


Categories