Shulou(Shulou.com)06/01 Report--

Insert a data Times into a materialized view base table:

ORA-12034: materialized view log on "SCOTT". "T_ROWID" younger than last refresh

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745

ORA-06512: at line 2

Solution:

SQL > exec dbms_mview.refresh ('MV_T_ROWID')

Begin dbms_mview.refresh ('MV_T_ROWID'); end

ORA-12034: materialized view log on "SCOTT". "T_ROWID" younger than last refresh

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745

ORA-06512: at line 2

Use full refresh:

SQL > exec dbms_mview.refresh ('MV_T_ROWID','C')

PL/SQL procedure successfully completed

Successfully insert data into the materialized view base table again.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.