Re: Multimaster Replication: Transform Data

On 22 Sep 2004 12:16:55 -0700, froliol_at_yahoo.com (Louis Frolio) wrote:

>Greetings All, is there some mechanism via Oracle Streams or Advanced
>Replication (yes I am in the process of reading the documentation) to
>transform the data being pushed? As an example, in MSSQL 2000 you can
>use DTS as part of the replication process to transform the data
>during replication. At this point of my inquiry I need only know if
>it is possible. As a scenario I need to do bi-directional replication
>on an existing product/db that is not inherently configured for
>replication. What I was thinking of doing was to take the primary key
>(artificial key, sequence generated) of a table and while it is being
>pushed add some number to it, say 20,000,000. This number will be a
>function of the theoretical limit(based on business rules) of that
>primary key for that row. If I can do this I can in essence
>horizontally partition the data and avoid collisions. I know this
>option is not clean and is probably rife with holes, however, as I
>said at this point I am only in the investigation phase of the process
>and want to understand my options.
>
>Louis Frolio

Replication is replication is replication: no transformation possible. Seems you need to resolve this by setting the 2 sequence generators 20000000 apart, and you won't have collisions and you won't have holes.

--
Sybrand Bakker, Senior Oracle DBA