Database DataWarehousing (MOSC)

MOSC Banner

Materialized view logs are not getting purged

edited May 29, 2014 12:00PM in Database DataWarehousing (MOSC) 10 commentsAnswered

Materialized view logs are not getting purged till down stream materialized views with complete refresh are done with refresh. Here is a simple test case.

SQL> create table tab1(a number primary key, b varchar2(10));

Table created.

SQL> create materialized view log on tab1;

Materialized view log created.

SQL> create materialized view mv_force refresh force as select * from tab1;

Materialized view created.

SQL> create materialized view mv_complete refresh complete as select * from tab1;

Materialized view created.

SQL> insert into tab1 select level, 'AAA' from dual connect by level <= 10;

10 rows created.

SQL> commit;

Commit complete.

SQL> exec dbms_mview.refresh('MV_FORCE');

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