GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Replication to different schema and table

edited Mar 2, 2013 9:23PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
 I have couple of questions on Streams configuration:
1. Replication from SOURCEDB.TAB1  into DESTNDB.TAB2

Streams working only if the schema and table name are same for replication database.  How to make it work if the source needs to be replicated to different schema and different table?  I was going through the document that this can be done with message transformation by modifying the rule set.  Can anyone did this before or provide information of achieving this?

2. Delay in propagation
The replication occurs as soon as the data changes. Can we delay the propagation or apply process for specified amount of time?  I tried to schedule propagation with dbms_schedule_popagation for increasing the latency but still now luck.  Since we sue 11g, I don't find _job_queue_interval parameter

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center