Re: Materialized View on Oracle 9i mastered by Oracle 8.1.6

Hmm... this is not easy and proven quite buggy. I have done similar with a master site being 8.1.7.4 and MView site being 9.2.0.2, and have seen the same error sometimes. Your best bet is to upgrade the master site to 9i.

Marc S. Gibian (marc.gibian_at_acm.org) wrote:
: I have a need to create a Materialized View on an Oracle 9i server
: that is mastered on an Oracle 8.1.6 server. We have given this a try,
: but we get the following errors when attempting to refresh with this
: configuration:

: SQL> BEGIN
: 2 DBMS_REFRESH.REFRESH ('REP') ;
: 3 END ;
: 4 /
: BEGIN
: *
: ERROR at line 1:
: ORA-02055: distributed update operation failed; rollback required
: ORA-02068: following severe error from TEST.WORLD
: ORA-03113: end-of-file on communication channel
: ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
: ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
: ORA-06512: at "SYS.DBMS_IREFRESH", line 683
: ORA-06512: at "SYS.DBMS_REFRESH", line 195
: ORA-06512: at line 2

: - -locla database :
: SQL> select * from v$version ;

: BANNER
: ----------------------------------------------------------------
: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
: PL/SQL Release 9.2.0.1.0 - Production
: CORE 9.2.0.1.0 Production
: TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
: NLSRTL Version 9.2.0.1.0 - Production

: My questions:

: 1 - Is it possible to successfully setup a materialized view in this
: configuration?

: 1a - If not, is there another configuration of Oracle replication that
: will allow propagating from a 8.1.6 master to a 9i target?

: 2 - Are there any special considerations that need to be taken into
: account for this cross-version replication configuration?

: Thank you very much in advance for your assistance.

: Sincerely,
: Marc
Received on Thu Feb 26 2004 - 18:24:48 CST