Database DataWarehousing (MOSC)

MOSC Banner

Materialized view invalid state

edited Jan 14, 2010 12:57AM in Database DataWarehousing (MOSC) 3 commentsAnswered
 Hello All

i do find that the materialized view is always in invalid state even after complie

i tried to drop and recreate but still the materialized views are in invalid state after query refresh in oracle 10g.

kinldy let me know how i can solve this issue

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