Hi All,
I have created few materialized views in Oracle 11g to use them in reports.The materialized was created with BUILD DEFERRED with the refresh to start after 15mins as we progress the changes to other environments through patching process and refresh of materialized view could take more time. I created the materialized view with BUILD DEFERRED USING INDEX REFRESH COMPLETE ON DEMAND START WITH sysdate+1/96 NEXT TRUNC(sysdate+1) + 1/24 USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE.
But the materialized view refresh never works and I have created job to refresh the materialized view everyday using dbms_refresh.refresh, which is working fine. Could you please help me to get the materialized view working with the definition of the materialized view itself without having a job to refresh it.
Please let me know if you need any further details
Regards,
Sri