Creating Materialized Views in R12.2.x

- In 12.1.3 where we create a materialized views with simple CREATE statement but in 12.2.x, we need to do below steps –- Create a logical view- Use ad_zd_mview upgrade script to create a materialized view. - Oracle internally creates required edition materialized view.e.g.- Create a logical view. Basically, create a normal view but suffixed by the #CREATE OR REPLACE VIEW APPS.XYZ_VIEW_NAME# AS<query>;-...

Read More