MVIEW Archive

Oracle Database 12c: The Out of Place Materialized View refresh

Introduction: Prior to Oracle database 12c, Materialized View refresh was always an in place refresh, which means the changes were made in the existing materialized view table either by delete/insert, truncate/insert or append/insert method. However, beginning with

ORA-01555 from 11g target database while refreshing MVIEW

Symptom: MVIEW refresh is getting failed with following errors. ORA-12012: error on auto execute of job 31030 ORA-12008: error in materialized view refresh path ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3$" too small
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed