Database DataWarehousing (MOSC)

MOSC Banner

11g materialized view refresh

edited Sep 30, 2010 10:19PM in Database DataWarehousing (MOSC) 3 commentsAnswered
 Hi,

Can Oracle 11g only refresh the columns in the mv? In other words, for the sample tables and mv below, when the data changed for column a3 or b2, which are not in the mv definition, will Oracle refresh the mv?

My problem is that the mv refreshed too many times because the base tables have many more columns not in the mv. Is there any way to aviod the refresh on non-mv columns?

Here is an example:

Create table A ( a1 number not null, a2 varchar2(80), A3 DATE);

Create table B ( b1 number not null, a1 number, b2 varchar2(80), b3 DATE);

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