Re: Keep track of table changes
1- Add a timestamp field to your table(s).
Add a table to store the timestamp you last checked for updates.
According to your current timestamp you can retrieve all records between the current timestamp and the one you stored in your new table. Voila.
Update timestamps in new table.
2- Depends what version you use. Add insert triggers to all your tables and store added key in a new table. Query this new table to retrieve all new records. Voila.
Empty new table.
Grtz,
Guus
Subject
Written By
Posted
Re: Keep track of table changes
May 09, 2005 05:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.