Click to See Complete Forum and Search --> : Extracting a data


bang_dba
09-24-2003, 06:31 AM
I have to extract some data from a table in Database A to Database B.
The table structure on both the d/b are same. A daily job will extract the data from A to B using a DB link.

What is the best way to ensure that only newly inserted records in the table in A is extracted to the table in B.
Can somebody give me the common logic used.

jovery
09-24-2003, 06:56 AM
Do you have a timestamp or sequence column in the table, if so this is probaly the best way to select the data to be copied. Otherwise you could consider using MERGE

HTH

bang_dba
10-06-2003, 07:01 AM
Thanx jovery,
Can u pls explain me how this MERGE can be done....?