Database DataWarehousing (MOSC)

MOSC Banner

11gR2 invalid materialized view refresh results with outer joins

edited Jan 18, 2011 9:27PM in Database DataWarehousing (MOSC) 5 commentsAnswered
  Hi all,

Supposedly the bugs associated with these problems (6674549, 10092858) have been fixed in 11gR2, but I am still seeing issues with materialized view fast refresh correctness and performance when there are outer joins to two tables.  In particular in 11gR2,  I can create both materialized views that will include extra rows and materialized views that will do unnecessary full table scans when fast refreshed.  These two cases generate different SQL statements during the refresh to insert into the materialized view.  The incorrect insert does not check for the existence of rows that need to be updated.  The slow insert forces full 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