RE: How to backup incomming data?

why don't you just let the database create the keys. create a BEFORE INSERT
trigger in the database that will build the keys. in the same trigger you
can also compare the rest of the records to check for duplicate in other
values other than the keys.

-----Original Message-----
From: Victor Shvetsky [mailto:[email protected]]
Sent: Thursday, January 23, 2003 2:33 AM
To: Oracle
Subject: [oracle] How to backup incomming data?


Hi, I have a question that I could not find an answer to anywhere.

I have a reporting server that writes data to Oracle Database via SQLNET.
If that product fails, no data is written into DB.

So, our client asked us if we could add an additional reporting server 
that would write the same data into DB. This way, if one reporting server 
fails, the second one would still write data into DB, therefore, we would 
not lose the data.

The problem is that we need to merge the data, so that we do not have 
duplicate records. That does not sound too hard. The problem starts with 
the fact that some of the tables' unique keys are generated by the server, 
therefore, server A and server B would have two different unique keys for 
the record. Should we just use combination of other fields as a key to 
compare the records, or is there a better way?

Does anyone know of a good way to do it? 

Thanks,
Vic
[email protected]
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].