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