Oracle Real Time Data monitoring
Hello All
In our team, we are trying to create a solution where the real time data updates to Vendor/Vendor site updates are transferred as XML Messages to the third party system.
We do not prefer Golden Gate at the moment as it would involve Replication and another Database.
We tried PoC with Oracle CQN (Continuous Query Notification) - but it seems to not provide ROWIDs for changes involving more than 80-100 transactions at a time.
Please suggest if there is any work around to get the rowids of the changed data, irrespective of the number of rows /any other mechanism to identify data changes in real time.