Database DataWarehousing (MOSC)

MOSC Banner

Question regarding materialized view

edited Feb 23, 2010 10:08PM in Database DataWarehousing (MOSC) 5 commentsAnswered
 I have a question regarding materialized view. I have read many documents but  couldn't find anything. I am seeking guru's expert opinion now.

I have a materialized view log created on one server and materialized view created on another replicated server. The materialized view get refreshed every 30 minutes.

However, the materialized view log gets dropped pretty often after running MRP process. Of course, the refresh will fail when the materialized view log does not exist.

My question is, if I rebuild the materialized view log after it gets dropped, but does not drop and rebuild the old materialized view associated with the dropped materialized view log. Will the view still be able to get refreshed after I recreate the materialized view log?

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