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: Your views on Quest - Shareplex

RE: Your views on Quest - Shareplex

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 30 May 2001 16:17:55 -0700
Message-ID: <F001.00314CE3.20010530162307@fatcity.com>

>-----Original Message-----
>From: MacGregor, Ian A. [mailto:ian_at_SLAC.Stanford.EDU]
>
>The person giving the presentation on Shareplex
>stated  that there could be no chained rows when the sharepex file,
> apparently analogous to the log miner dictionary file is created.

Someone has already addressed this issue but I'll throw in my two cents again. There was a misunderstanding somewhere. When you "activate" shareplex (set up the software for replication, specifying objects to replicate, initial sync point, etc...) it's perfectly OK for tables to have chained rows, but the "activation" may take longer in that case.

>Truncate is not  DML it is DDL.  I didn't say there was a problem extracting
>DML statements.  Oracle's log miner utility will do that.
>I said that  Shareplex, as per the person who gave the presentation,
>will replicate truncates and marvelled at this capability.

I regret that the developer did not fully comprehend what you meant. I'm sure she would appreciate your compliment. She did want to make sure that it was understood that it would be possible to "replicate" DDL, but that feature isn't in high enough demand (yet) apparently.



Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Wed May 30 2001 - 18:17:55 CDT

Original text of this message

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