Database DataWarehousing (MOSC)

MOSC Banner

dbms_refresh

edited Oct 23, 2019 5:11AM in Database DataWarehousing (MOSC) 6 commentsAnswered

After the transition from 11.2.0.4 to 12.1.0.2, there was a nuisance when updating the refresh group.
If a group terminates with an error, then in addition to describing the error, it writes a list of materialized views that have not been updated by this group in alert_log. Can this be turned off (list of materialized views)?

In 11g this look like this

[SRC]

Errors in file /u01/oracle/ora12/diag/rdbms/cdb/CDB_1/trace/CDB_1_j009_47419.trc:

ORA-12012: error on auto execute of job "MVIEWADMIN"."REFRESH_SANG_CDS_DNS"

ORA-12048: error encountered while refreshing materialized view "SANG_CDS"."DNS_ATTRIBUTES"

ORA

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center