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» The Simpsons Track p2
» COFFEESHOP WAS DELETED
» www oracle-today ru ??????? ?????
» how to compare 2 ULR's which is exist in same web page (View page source).
» Best method to track deleted records on source in Oracle
» COFFEESHOP WAS DELETED
» www oracle-today ru ??????? ?????
» how to compare 2 ULR's which is exist in same web page (View page source).
» 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