I have a materialized view that is currently created with COMPLETE refresh, and I would like to change it to FAST refresh so that it can handle incremental loads.
I’ve included the code used to create the MV. Could someone please review the dynamic SQL and let me know if it meets the requirements for FAST refresh (incremental updates), or if any modifications are needed?
When I tried to apply fast refresh encountered the below error.
ORA-12004: REFRESH FAST cannot be used for materialized view "APPS"."XXBCT_CLASSIC_DYNAMIC_SBUWISEPERFTEST1_MVIEW" ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2432 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 88 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 253 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2413 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2976 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3263 ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3295 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 16 ORA-06512: at line 7
Dynamic Output for MV creation.sql