Since the redo log contains only details about object id, row location, and changed values , how do you derive a table-name and key value for the SQL to be applied ?
Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____England______January 21/23 ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -----Original Message----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 17 January 2003 19:25 >I was going to keep quite... but here goes. :) >----------------------------------------------------- > >Yes, of course I'll be glad to help. > >Basically... > >Log Based replication for Oracle. A capture process continually reads the >online redo logs and parses out information based on a list of tables you >provide. The raw redo log data is then converted into standard Oracle SQL, >and using OCI calls is posted to target database(s). The target(s) are >fully open and available, so you can do peer-to-peer, reporting, failover, >DR, upgrades, migrations... > >No SQL*Net, no Streams, no AQs, no triggers, no OAR. > >It's a pretty broad product, so if you need more info, just let me know. > >Nick > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).