Re: Database Replication on Oracle

Yao-Wen Stephen Tsai wrote:
>
> I am writing a report regarding database replication. I am wondering if anyone can provide detail
> on how the Oracle deal with the replication process. Also, how does is solve the problem on update
> conflict?
>
> Thanks for the help
>
> Yao-Wen Stephen Tsai

Although I can't tell you from my own experience, I may be able to shed some light on the replication by Oracle. As far as I have heard, Oracle uses time-stamps for checking if a table has changed. If it has, it sends the whole table to the replication-site. Might be some burden on the network/modem line if the table is somewhat large!

If anyone has more info on this, please let me know, I'd like to be corrected on this particular subject!

Roald.

-- 

+-------------------------------------------------------+
| R.A. van Geleuken                     roald_at_xs4all.nl |
+-------------------------------------------------------+
| There's no such thing as impossibility, only          |
| extremely low chance                                  |
+-------------------------------------------------------+