Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> New row value checking - for updating a table
Hi,
Is there a method, technique, 3-rd party software tool, anything that can check
for differences on a row level basis?
Here's what I want to be able to do...
I have a table ( 7000 rows 125 fields ) that I extract from another (
non-Oracle) database and then import into my Oracle instance...
This data changes every 2 or 3 days and, the only way I have found to keep up is to re-extract the data, truncate the table, and re-load all the data...
I would like to be able to only add new records and replace any that have any changes in one of the fields....
Can that be done?
Details:
Oracle 7.3.x.x on Netware 4.11 server
WinNT Client
To reply please remove the 'nospam' part of the address Received on Fri Feb 12 1999 - 11:21:28 CST
![]() |
![]() |