Re: Anybody parse Oracle logs to determine record deletions?

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