On 9/21/05, Sandeep Dubey <dubey.sandeep@xxxxxxxxx> wrote: > 1. Create triggers on the live table. For each insert/update/delete insert a > row in the audit table. Strange and unexpected things can happen with audit triggers. They can fire 2+ times for the same row in the right circumstances. See: http://tkyte.blogspot.com/2005/08/something-different-part-i-of-iii.html http://tkyte.blogspot.com/2005/08/part-ii-seeing-restart.html http://tkyte.blogspot.com/2005/09/part-iii-why-is-restart-important-to.html -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l