Materialized View on Oracle 9i mastered by Oracle 8.1.6

From: Marc S. Gibian <marc.gibian_at_acm.org>
Date: 26 Feb 2004 16:04:58 -0800
Message-ID: <8df11a0.0402261604.2dbba72a@posting.google.com>

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:04:58 CST