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