Re: Changes made in Oracle Tables

You can turn on audit for your table, which will log an audit trail for audited events. Or you may want to write a custom AFTER trigger that will keep a log of data changes. See Administrator's Guide and SQL Reference for more information on auditing and AUDIT command.

-- 
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"WISCO" <jb26_at_hotmail.com> wrote in message news:abkvuq$9be$1_at_coco.singnet.com.sg...


> How to determine if an oracle table has been updated?


> I try select * from all_tables but unable find out the time stamp like what

> we have in windows explorer.

> 

> Better still if I can know the exact record being changed.

> 

> Is there any utility to compare the table before and after any changes?

> 

>