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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: quest shareplex

Re: quest shareplex

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 17 Jan 2003 13:44:01 -0800
Message-ID: <F001.00533897.20030117134401@fatcity.com>

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 <ORACLE-L_at_fatcity.com> 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: jonathan_at_jlcomp.demon.co.uk

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: ListGuru_at_fatcity.com (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).
Received on Fri Jan 17 2003 - 15:44:01 CST

Original text of this message

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