Materialized view invalid state
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