Replication to different schema and table
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
0