RE: quest SharePlex

You provide a 'configuration file' which is just a flat file of table names on the source machine and table names on the target machine. Then we go through an activation process that takes the table name on the source and grabs the object id from Oracle and the primary key columns (if no primary key, we use all the columns except for LOB's and LONGs). Then the capture process scans through the redo logs only capturing changes to object ids in our list.

configuration file is pretty simple...

source_owner.source_table target_owner.target_table target_system_at_o.SID

so to replicate scott.emp to scott2.emp2 on system XYZ, with instance ORCL it would be...

scott.emp scott2.emp2 XYZ_at_o.ORCL

However, it can get complicated if you want to replicate only certain columns, or only certain rows.

-----Original Message-----
Sent: Friday, January 17, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nick Wagner
  INET: Nick.Wagner_at_quest.com

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).