Database DataWarehousing (MOSC)

MOSC Banner

Broken Refresh Groups

edited Nov 21, 2019 4:43AM in Database DataWarehousing (MOSC) 4 commentsAnswered

Good morning,

Recently we've had a couple of issues with our Materialised View Logs and Refresh Group setup on 12.2 databases.

When scripts that touch the Refresh Group fail for any given reason such as TEMP FULL or DEADLOCK, the Refresh Groups appear broken and none of the subsequent scripts run either.

Unfortunately, there is no information in my logs. I have just come to learn that if something goes wrong with a script that references our Refresh Groups, a drop and recreate will solve the situation.

I just don't understand why! Does anyone have a more extensive understanding of Refresh Groups?

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