Home » Server Options » Replication » Need to do a net change on data of two tables
Need to do a net change on data of two tables [message #75300] Wed, 18 December 2002 00:00
all4seasonsin1day
Messages: 1
Registered: December 2002
Junior Member
The problem:
I have two tables (>1 million records) 'Yest' and 'Today' which are structurally identical (same column names, cardinality and constraints). The data in 'yest' table may have changed (adds, deletes, changes). I need to get a net-change between the two tables' data, identifying which records from 'yest' have changed in 'today', which have been deleted from 'yest', and which have been added to 'today'. I tried with minus and not-in operators. But the performance is poor. Any leads?
The db version is Oracle 8i.
Thanks!
~all4seasonsin1day
Previous Topic: How to Replicate DDL instructionts without resuming the Replication? is that possible?
Next Topic: Snapshot Refresh Options
Goto Forum:
  


Current Time: Thu Nov 26 03:59:38 CST 2020