Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> New row value checking - for updating a table

New row value checking - for updating a table

From: TurkBear <johng_at_nospam.mm.com>
Date: Fri, 12 Feb 1999 17:21:28 GMT
Message-ID: <36c461e3.4216893@news2.mm.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US