Re: Anybody parse Oracle logs to determine record deletions?

Sounds awfull complicated and manhour intensive. What about a 'BEFORE DELETE' trigger. The trigger would capture the deleted record and send it across a link to your other instance and perform an insert on your new deleted records table. All this would occur immediately prior to the record being deleted. You could even capture the userid and associate it with the deleted record in your new table.

                                                                                Dennis Brewer
                                                                               System DBA

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.
>
>Thanks!
>Tom Lavelle
Received on Tue Apr 30 1996 - 00:00:00 CEST