Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Your views on Quest - Shareplex
>-----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.
![]() |
![]() |