5 minutes after the time that your user told you prior to doing a PITR. :(= =20 Niall > -----Original Message----- > From: mln@xxxxxxxxxxxx=20 > Sent: 15 February 2004 21:10 > To: mln@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx > Subject: Re: Row Creation >=20 >=20 > A block dump might reveal the SCN of the latest update of a=20 > row, but I=20 > don't think what you're asking is possible. So an insert=20 > trigger and a=20 > date column might be the way to go. >=20 > Mogens >=20 > Keith M Cutler wrote: >=20 > >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 > >----------------------------------------------------------------- > > > > =20 > > >=20 >=20 >=20 > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- >=20 >=20 ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- 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 -----------------------------------------------------------------