ORA-12034 while doing a COMPLETE refresh.
Trying to understand how it's possible to get ORA-12034 while doing a COMPLETE refresh on a materialized view?
Oracle 19.18.0.0.0
All the documentation/notes/metalink indicates this is an error for FAST refresh mat views, and to resolve, you should do a COMPLETE refresh.
We got this error on a COMPLETE refresh. Upon re-running the command, it worked fine - no errors.
What could possibly be causing this ?
Command run:
begin dbms_mview.refresh('MY_SCHEMA.MY_MAT_VIEW', 'c', atomic_refresh=>false); end;
error was:
ORA-12034: materialized view log on "OTHER_SCHEMA"."CHILD_TABLE" younger than last refresh
MY_MAT_VIEW, has following dependencies:
Tagged:
0