Hi,
When executing fast refresh over DbLink on MView "snapshot to old" error is returned.
Refresh is executed at database DB_MV:
dbms_mview.refresh( list => 'MV_TABLE_NAME');
Master table is located on DB_MASTER
At execution time:
- only 10% of UNDO is used at DB_MV database
- undo_retention=7200 (2 hours) ad DB_MV database
- error is returned after 47minutes
Is it possible that snapshot to old occurres on DB_MASTER database?
Do you have any idea where to check why this error occurres?
Full error returned is:
------------------------
ORA-12008: error in materialized view refresh path
ORA-01555: snapshot too old: rollback segment number 71 with name "_SYSSMU71_2731661872$" too small
ORA-02063: preceding line from MOBCST1_MVIEWS
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 1
Br,
Dario