OraFAQ Forum: Replication » Need to do a net change on data of two tables

Home » Server Options » Replication » Need to do a net change on data of two tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	How to Replicate DDL instructionts without resuming the Replication? is that possible?
Next Topic:	Snapshot Refresh Options

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:51:25 CDT 2024