Re: quest SharePlex

2003-01-22 Thread Jonathan Lewis
Very cute - this tends to suggest that Shareplex is spotting the appearance of chains in the log and storing the list of rowids. Would the same thing work if you shut down the Shareplex processes after the row had chained, and restarted them before you updated the chained piece ? And does

RE: quest SharePlex

2003-01-22 Thread Nick Wagner
Title: RE: quest SharePlex Would the same thing work if you shut down the Shareplex processes after the row had chained, and restarted them before you updated the chained piece ? -- Yes And does Shareplex guarantee that it will never report a 1555 error regardless of how long it is shut

Re: quest SharePlex

2003-01-22 Thread Jonathan Lewis
Nick, Thanks for the notes. I've often wondered how Shareplex did its thing. Just for kicks - have you tried writing a collision handler for streams ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see

RE: quest SharePlex

2003-01-21 Thread Nick Wagner
Title: RE: quest SharePlex This is actually part of the 'magic' of SharePlex. The way we obtain the PK information from the database if the PK was not modified is very tricky. I can tell you some of the 'magic' but not all of it. (NDA type stuff) In all updates the redo logs contain

RE: quest shareplex

2003-01-20 Thread Martin, Alan
Title: RE: quest shareplex Has anyone used Oracle Streams for simple A to B replication? Likes/dislikes? Can it be used in 8.1.7? Thanx, Alan Martin Defense Logistics Information Service [EMAIL PROTECTED] -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent

Re: quest SharePlex

2003-01-19 Thread Jonathan Lewis
Thanks for the reply. That covers the object/data_object id problem, and gives the ability to identify which columns in the dump are the primary key columns. But when you update a row, the redo will only contain the primary key if the primary key has been modified, so you should hardly ever find

RE: quest shareplex

2003-01-17 Thread Richard Ji
Quest Shareplex is a replication software. Nick Wagner from Quest is on this list and he is been very helpful and I am sure he will be glad to provide you info on it. Right Nick? :) -Original Message- Sent: Friday, January 17, 2003 11:14 AM To: Multiple recipients of list ORACLE-L I'm

RE: quest shareplex

2003-01-17 Thread Paula_Stankus
Title: RE: quest shareplex It allows for master to master replication. My understanding is that Oracle's Data Guard now does the same thing. Shareplex was faster then replication with less latency because it would read from the online redo files from Oracle. I understand that Data Guard now

RE: quest shareplex

2003-01-17 Thread Nick Wagner
Title: RE: quest shareplex 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

Re: quest shareplex

2003-01-17 Thread Jonathan Lewis
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

RE: quest shareplex

2003-01-17 Thread Khedr, Waleed
I'm sure you know Oracle has a new product Oracle Streams that does the same: http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server .920/a96571/strmover.htm#43906 Waleed -Original Message- Sent: Friday, January 17, 2003 11:14 AM To: Multiple recipients of list

RE: quest SharePlex

2003-01-17 Thread Nick Wagner
Title: 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