TechExuberance

This is typical scenario for customers using materialized views to replicate below error - SQL> exec dbms_mview.refresh('SAMPLE_TB_MV','c',ATOMIC_REFRESH => FALSE); BEGIN dbms_mview.refresh('SAMPLE_TB_MV','c',ATOMIC_REFRESH => FALSE); END; * ERROR at line 1: ORA-12008: error in materialized view refresh path ORA-00947: not enough values ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017 ORA-06512: at line 1 Base Table - create table sample_tb(id number primary key,name varchar2(10),val number); Insert data - insert into sample_tb values(1,'ABC',99); Materialized View - create materialized view sample_tb_mv as select * from sample_tb; Check data - select * from sample_tb;         ID NAME              VAL ---------- ---------- ----------          1 ABC      ...