Database DataWarehousing (MOSC)

MOSC Banner

Materialized view demanding complete refresh

edited Feb 1, 2010 7:50PM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi There,

I am having a problem with one of my Oracle 11g R2 database. I have two other oracle servers that pulls data from this database using mviews. the problem is that when I create mview of same table on both database, i am not able to fast refresh my mviews. only the latest created mview gets fast refresh but the other one start giving "Materialized View Log Younger Then Last Referesh". if I do a complete refresh for the first mview then the other one starts giving this error.

i.e. i tried following commands

On DB1

 Create Materialized View Log On Base_Table

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