Database DataWarehousing (MOSC)

MOSC Banner

Materialized view becoming invalid after a DML on base table(s)

edited Oct 2, 2012 8:00PM in Database DataWarehousing (MOSC) 3 commentsAnswered
Here is my question.  I have a materialized view that is refreshed on a daily basis. Immediately after it is refreshed, it shows a valid status.  But, a few minutes later, due to a DDL or DML occuring on the base tables, the materialized view becomes invalid.  I can query it and get records back. Is this normal behavior or a bug?

A sample of the create materialized view is listed below, with the refresh statement at the very end:

CREATE MATERIALIZED VIEW "SCOTT"."MV_SAMPLER"  
  TABLESPACE "TEST_DATA"
  BUILD IMMEDIATE
  USING INDEX TABLESPACE "TEST_INDEX"
  REFRESH FORCE ON DEMAND

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