Home » Server Options » Replication » Snapshot replication without deletes ?
Snapshot replication without deletes ? [message #75234] Wed, 07 August 2002 13:38
Messages: 67
Registered: June 1998
Does anyone have any suggestions on how to replicate inserts and updates but not deletes from a master site to a snapshot site? We want to replicate data from a production database to a decision support database but not delete data from the decision support database due to retention requirements. I was going to replicate master tables to the snapshot site then using triggers defined on the snapshots, insert or update rows into the final tables that the user would see. But Oracle told me triggers on snapshots are unsupported. Any ideas?
Previous Topic: Oracle Standby with 8i
Next Topic: replication problem
Goto Forum:

Current Time: Mon May 16 01:01:32 CDT 2022