Advertisement

07.21.2008 at 02:11AM PDT, ID: 23581205
[x]
Attachment Details

Oracle 9i to 10g Replication

Asked by Airbornelove in Oracle 10.x, Oracle 9.x

Tags: Oracle, Oracle 10g, 10g, Database

Dear Experts,

I have successfully replicated data of a single table from Oracle 9i to Oracle 10g.  I set the materialized view to "updatable" (see the reason below).  

Question:  Is it possible to use the Replication feature of Oracle to do an INSERT ONLY on the destination tables?  I need to replicate only the new records from the source tables and a program in the destination server will do the updates on those replicated records.  Updates from the source tables should not reflect on the destination tables.  Any sample scripts on this?

Thanks and more power!



Start Free Trial
 
Keywords: Oracle 9i to 10g Replication
Title
1 oracle replication
2 Oracle Replication
3 schema replication.
4 Oracle replication
5 Oracle replication
6 Oracle Replication
 
Loading Advertisement...
 
[+][-]07.25.2008 at 04:46AM PDT, ID: 22087573

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Oracle 9.x
Tags: Oracle, Oracle 10g, 10g, Database
Sign Up Now!
Solution Provided By: schwertner
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628