A block dump might reveal the SCN of the latest update of a row, but I don't think what you're asking is possible. So an insert trigger and a date column might be the way to go. Mogens Keith M Cutler wrote: >Anyone know off hand where I can find the date a row was created? > >Keith M. Cutler >Oracle 8i Certified DBA >keith@xxxxxxxx >www.etix.com >919.782.5010 office >919.782.7727 fax > > >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------