Can any one help me????
Are you saying that on the source, you will do an insert for example, but on the target, you only want that data to be replicated if the timestamp column is within 90 days?
For that INSERT on the source, is the TIMESTAMP data going to be current sysdate always, or could it actually be older than current time, such as 120 days ago?
Thats it mb_ogg, just only 90 days on target. The production side have a lot of months and years of data, but in my OGG side I whant just 90 days of data.
Can you help me with a example?
what kind of OGG configuration do you have there ? uni-directional or bi-directional ?
Check this link with information to implement sqlexec with a lot of examples:
Maybe you can replicate your hole table to the target and then implement a Trigger on your target to delete what you dont want. I don't know if this is possible, bus you can test it, only for Unidirectional replication.
J.A tank you very much for your response. I saw this note about sqlexec, but i dont understand very well. It's a big problem, I need a exemple of this. About the trigger, I can do this, but this is a big project and the clinte never accept that solution, can you understand me? It's very complicated.
I need some examples about this condition, how can I do, how can I use, how type sqlexec a need to do to have a success script.
Thanks and wait
I recommend you to install a Test environment
- Have you done this ?, because you have to test the correct configuration for OGG before you implement on production, then try the SQLEXEC configuration
- Have you ever installed and configured OGG before ?
- Maybe another "workaround" that could help you but maybe its not the best solution: Implement a copy of your production table, only with the information that you need (condition > 90 days). Load this second table with a Job in your production DB. Then OGG just will copy this table from Source to the target DB.