Link to home
Start Free TrialLog in
Avatar of Airbornelove
Airbornelove

asked on

Oracle 9i to 10g Replication

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!



ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial