Questions about heartbeat tables and schema-level stream in 10g
We are going to implement a schema level streams to replicate data in 10g environment.
I have two questions:
1. heart beat table ( based on Metalinnk Note:418755.1)
I don’t fully understand the explanation about the purpose of heartbeat in this note. Basically, what is the purpose of heartbeat table?
How to implement it? Any example from the real life?
2. I used to implement some streams in specific tables. But this time we will do schema-level streams. Any difference? I still have to do all table-level streams under this schema or there is some new function which allows me to specify the schema-level?
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.