Updatable materialized view fast refresh failure between Oracle 8i and 9i 2004-02-24 - By Suhen Pather (S)
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@(protected)
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@(protected)
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 (See ORA-12008.ora-code.com): error in materialized view refresh path
ORA-02064 (See ORA-02064.ora-code.com): distributed operation not supported
ORA-02063 (See ORA-02063.ora-code.com): preceding line from LINK1
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT ", line 794
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT ", line 851
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT ", line 832
ORA-06512 (See ORA-06512.ora-code.com): 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@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
