I'd like to set up some Oracle triggers to take action after rows are inserted, but I can't do this on our production database because it's controlled by a vendor. One alternative I was looking at is doing Oracle Dataguard replication to a secondary database somewhere, and setting up triggers there to take my action. However, I've gotten the impression that I can't modify the Dataguard destination in any way, even if my triggers won't have impact on the data at all (they're all AFTER triggers).
Can I use dataguard in this way? If I can't, are there are other alternatives to Dataguard, like maybe Oracle streams? Some other type of replication?
Best Answer
If you setup a logical standby, then you can change the data in the logical standby. You will probably have trouble supporting the kind of change that you seem to want. Have you thought about talking to the vendor to see if they can add the logic that you want to the product you pay them for? If the vendor makes the change, then they will/should support it. You can create materialized views in a different schema and add whatever functionality that you want to the materialized views. You then just need to refresh them when needed.