Database DataWarehousing (MOSC)

MOSC Banner

Materialized views

edited Jan 14, 2010 1:37AM in Database DataWarehousing (MOSC) 5 commentsAnswered
Hi
The Materialized refresh job defined in dba_job is not executing since a week.

I have checked with the basic troubleshooting :

1) Job_que_processes
2) Checked with Mview master object(source table)  whether the source table is modified recently which may have invalidated  mview in getting refreshed
3) Checked with db_link , which is used for refresh , and it is working fine ( as other materialized views get refresh thru same db_link)
4)network is good

5) Materialized view logs ----i need some help on this ...can this be a reason that mview logs are growing larger ?
The table consists of only 24101 rows. Kindly suggest how should i troubleshoot further ....

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