SQL> begin dbms_mview.refresh(‚TALMASTER.TBLTAG‘,’F‘);end;/ 2 3 4begin*ERROR at line 1:ORA-12031: cannot use primary key columns from materialized view log on „DOTTK_ADM“.“TBLTAG“ORA-06512: at „SYS.DBMS_SNAPSHOT“, line 2254ORA-06512: at „SYS.DBMS_SNAPSHOT“, line 2460ORA-06512: at „SYS.DBMS_SNAPSHOT“, line 2429ORA-06512: at line 2Elapsed: 00:00:01.09SYS@dottk SQL> ALTER MATERIALIZED VIEW LOG ON „DOTTK_ADM“.“TBLTAG“ ADD PRIMARY KEY;Materialized view log altered.SQL> begin dbms_mview.refresh(‚TALMASTER.TBLTAG‘,’F‘);end;/ 2 3 4begin*ERROR at line 1:ORA-12034: materialized view log on „DOTTK_ADM“.“TBLTAG“ younger than last refreshORA-06512: at „SYS.DBMS_SNAPSHOT“, line 2254ORA-06512: at „SYS.DBMS_SNAPSHOT“, line 2460ORA-06512: at „SYS.DBMS_SNAPSHOT“, line 2429ORA-06512: at line 2ReplikaSQL> drop MATERIALIZED VIEW „TALMASTER“.“TBLTAG“;Materialized view dropped.Elapsed: 00:00:02.02SQL> CREATE MATERIALIZED VIEW „TALMASTER“.“TBLTAG“ TABLESPACE „DOTTK_MAIN“ PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 1024K BUFFER_POOL DEFAULT) NOLOGGING USING INDEX TABLESPACE „DOTTK_MAIN“ PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 1024K BUFFER_POOL DEFAULT) REFRESH FORCE ON DEMAND AS SELECT „TBLTAG“.“FLDTAGNR“ „FLDTAGNR“ 2 , „TBLTAG“.“FLDTAG“ „FLDTAG“ 3 , „TBLTAG“.“FLDCOUNT“ „FLDCOUNT“ 4 FROM „TBLTAG“@DOTTK.TALOHA.TK „TBLTAG“;Materialized view created.Elapsed: 00:01:03.72SQL> begin dbms_mview.refresh(‚TALMASTER.TBLTAG‘,’F‘);end;/ 2 3 4PL/SQL procedure successfully completed.Elapsed: 00:00:00.11



Komentáře