I'm in the process of creating a reporting 8i database of several tables from several different 8i databases. I was planning to use snapshots but then a requirement of real time data on the reporting database was brought up. I have done something like this in the days of Oracle 8 via a data synchronization C/Pro C program. However, in that case there was quite a bit of business rule enforcement that justified the use of code.

Does anyone have any tips on how this can be done using any built in Oracle mechanisms? Will Advanced Replication work? I've never used it before.

Thanks!