Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Multimaster Replication: Transform Data
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 Received on Wed Sep 22 2004 - 14:16:55 CDT