Best method to track deleted records on source in Oracle
Page 1 of 1 • Share •
Best method to track deleted records on source in Oracle
We need a way to track deleted records from the source tables in Oracle. We have one source Oracle database and our data warehouse is also in Oracle. I'm somewhat familiar with CDC (asynchronous would do the job) to tap into the logs, but is there anything else in Oracle I could use?
Any ideas of best practices? I only have a few of them. Like 30 records per month. What is the best option?
I heard of a materialized view log being enabled in the source log. The materialized view in the target and do a fast refresh from the mv log in the source (replication using snapshot). It sounds like the same thing as CDC, but anybody heard of this?
Any ideas of best practices? I only have a few of them. Like 30 records per month. What is the best option?
I heard of a materialized view log being enabled in the source log. The materialized view in the target and do a fast refresh from the mv log in the source (replication using snapshot). It sounds like the same thing as CDC, but anybody heard of this?
dellsters- Posts: 35
Join date: 2009-02-11
Re: Best method to track deleted records on source in Oracle
You can use Oracle Streams to track delete in source oracle table.
rgupta614- Posts: 1
Join date: 2010-10-06
Similar topics» COFFEESHOP WAS DELETED
» www oracle-today ru ??????? ?????
» The Simpsons Track p2
» Track your lost mobile using IMEI No.
» Best method to track deleted records on source in Oracle
» www oracle-today ru ??????? ?????
» The Simpsons Track p2
» Track your lost mobile using IMEI No.
» Best method to track deleted records on source in Oracle
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum