Database DataWarehousing (MOSC)

MOSC Banner

11g materialized view refresh

edited Jun 16, 2010 8:19PM in Database DataWarehousing (MOSC) 2 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.

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);

CREATE MATERIALIZED VIEW LOG ON A WITH ROWID;

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