Sure. The general rule is that if you can create a database link between the two systems, you can use materialized view replication. Oracle 9.2 connects to Oracle 8.0 and later systems, so you're fine. You could even upgrade the 9.2 database to 10g and still be able to replicate, since 10g connects to 8.1.7.4 and later systems.=20 Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Loughmiller, Greg Sent: Monday, April 26, 2004 7:25 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: Oracle versions and replication... Folks, Monday morning chaos and question.. Is it possible to replicate (via snapshots) from an Oracle 8174 DB to a 9204 DB?? =20 Thanks in advance Greg Loughmiller Sr Manager - Enterprise Data Architecture Office: 678.893.3217 ips: gloughmiller This email, and any attachments, are intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. It is the property of Cingular Wireless. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, any attachments thereto, and any use of the information contained is strictly prohibited. If you have received this email in error, please notify me at 678-893-3217 and permanently delete the original and any copy thereof. =20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------