Re: Anybody parse Oracle logs to determine record deletions?

SQL Trax, marketed by BMC software does a good job of parsing redo logs, both online and archived. It produces SQL for undo & redo actions although the delete you mentioned would show up as a delete by rowid rather than as a delete qualified by a primary key. SQL Trax will also create table access and transaction timing statistics reports.

Mary Travis
BellSouth

fossa_at_its.it (Mauro Fossa) wrote:

>lavelle_at_netcom.com (Tom Lavelle) wrote:
 

>>Has anybody attempted to parse Oracle's logs to determine deletions
>>from tables? We are "replicating" an Oracle table by determining records
>>that have changed (date stamp), extracting them to a flat file, transporting,
>>and inserting or updating into a copy of the database. Deletions, however,
>>simply fall off the source database. We are trying to build a mechanism
>>to propagate these deletions. I've peeked into the redo logs and they're
>>not very readable - has anybody devised a means of parsing these files
>>(which definitely contain this information) to determine which records
>>have been deleted?
>>Please copy response to lavelle_at_netcom.com.
 

>What about a trigger ? (BTW, that's how Oracle Replication works...).
 

>>Thanks!
>>Tom Lavelle

>---------------------------------------------
>Mauro Fossa (fossa_at_its.it)

Mary Travis
email Mary.B.Travis_at_bridge.bellsouth.com Received on Fri May 10 1996 - 00:00:00 CEST