| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> updatable materialized view fast refresh failure between Oracle 8i and 9i
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: 7bit
==============================================================================This e-mail and its contents are subject to the Telkom SA Limited e-mail legal notice which can be viewed at:http://www.telkom.co.za/TelkomEMailLegalNotice.PDF Should you be unable to access the link provided, a copy of the legal notice will be e-mailed to you on sending an e-mail to legalnotice_at_telkom.co.za List
We seem to have an issue with an updatable materialized view fast
refresh between Oracle 8i and 9i.
The error occurs with the set-up from 9i to a 8i master. The procedure
works with 9i to 9i implementation.
Anyone experience a similar issue or have a resolution?
Master site : 8.1.7.4
Snap site : 9.2.0.4.0
OSS : HP-UX 11 i
SQL> l
1 create materialized view mview_8i
2 tablespace xxxx
3 using index tablespace xxxx
4 REFRESH FAST START WITH SYSDATE
5 WITH ROWID for update AS
6* SELECT * from bentest_at_link1
SQL> /
Snapshot created.
SQL> execute dbms_snapshot.refresh('mview_8i','F');
PL/SQL procedure successfully completed.
SQL> alter table mview_8i add (extra_col date);
Table altered.
SQL> execute dbms_snapshot.refresh('mview_8i','F');
PL/SQL procedure successfully completed.
SQL> update mview_8i set extra_col=sysdate;
23 rows updated.
SQL> commit;
Commit complete.
SQL> execute dbms_snapshot.refresh('mview_8i','F'); BEGIN dbms_snapshot.refresh('mview_8i','F'); END;
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path ORA-02064: distributed operation not supported ORA-02063: preceding line from LINK1 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 832 ORA-06512: at line 1
SQL> execute dbms_snapshot.refresh('mview_8i','C');
PL/SQL procedure successfully completed.
SQL> update mview_8i set extra_col=sysdate;
23 rows updated.
SQL> commit;
Commit complete.
Workaround
SQL> truncate table USLOG$_MVIEW_8I;
Table truncated.
SQL> execute dbms_snapshot.refresh('mview_8i','F');
PL/SQL procedure successfully completed.
SQL>
Many Thanks in Advance
Kind Regards
Suhen Pather
IT Software Specialist
Land +27 12 680 3282
Cell +27 82 562 3124
email pathes10_at_telkom.co.za
 |
 |