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
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.
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