Best method to track deleted records on source in Oracle

View previous topic View next topic Go down

Best method to track deleted records on source in Oracle

Post  dellsters on Thu Sep 23, 2010 11:56 am

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?

dellsters

Posts : 39
Join date : 2009-02-11

View user profile

Back to top Go down

Re: Best method to track deleted records on source in Oracle

Post  rgupta614 on Wed Oct 06, 2010 10:43 am

You can use Oracle Streams to track delete in source oracle table.

rgupta614

Posts : 1
Join date : 2010-10-06

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum