There is a table A which is having millions of records which are continusly being updated by some process. And there is a procedure in another dB, which reads the records from table A and inserts into table B.
Now after insertion if any change happens to that row in table A, then B won't have the latest record.
How to overcome this situation? I don't want to use materialised view in this scenario. Also I can't create trigger on table A. What do I do in this situation in order to have updated or latest records in table B?
Thanks in advance.