For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Materialized views state turns into compilation_error after refresh.They are getting created successfully but soon turns into compilation_error later.
I have bunch of views in schema and only 4 are turning into valid state.Any pointers on this