Home » Other » General » Identification of DELETE record from REDO Logs (oracle 11g)
Identification of DELETE record from REDO Logs [message #503311] Thu, 14 April 2011 05:02 Go to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi,

We are using Oracle CDC to transfer data from SOURCE to STAGING Database.
Purging the data after 3 days from STAGING database.

From Staging Database we generate the data file.

If any data is coming after 3 days than using MERGE principle in data file to make the data consistency for INSERT and UPDATE operation.

But for DELETE operation, which happens after 3 days. ????

How track DELETED records as it will not find the data in STAGING database?

Is there anyway to identify the DELETED records in REDO logs or else any suggestion?
Re: Identification of DELETE record from REDO Logs [message #503314 is a reply to message #503311] Thu, 14 April 2011 05:43 Go to previous message
Michel Cadot
Messages: 67952
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Log Miner can give you all deletes (as well as all other DML and DDL).

Regards
Michel
Previous Topic: No more puzzles?
Next Topic: How to create a database using different number system
Goto Forum:
  


Current Time: Mon Sep 27 11:43:10 CDT 2021