How far back can you go? From: David Litchfield [mailto:david@xxxxxxxxxxxxxxxxxxxx] Sent: Friday, June 20, 2008 10:12 AM To: Langston, Chris; 'Jared Still' Cc: 'oracle-l' Subject: RE: Determine Record Creation Date Without Audit Turned On Is it not possible to use a flashback query to determine the records in question; or alternatively the redo logs? HTH, David ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Langston, Chris Sent: 19 June 2008 19:40 To: Jared Still Cc: oracle-l Subject: RE: Determine Record Creation Date Without Audit Turned On At best I can only make the recommendation. They'll have to weigh if it's worth the effort to get the approvals to get it done. From: Jared Still [mailto:jkstill@xxxxxxxxx] Sent: Thursday, June 19, 2008 11:31 AM To: Langston, Chris Cc: oracle-l Subject: Re: Determine Record Creation Date Without Audit Turned On On Wed, Jun 18, 2008 at 7:44 AM, Langston, Chris <Chris.Langston@xxxxxx> wrote: All, We have a user that needs to do cleanup on a table in a 10.2 instance and wants to remove rows in a table based on when the record was created but there is no creation date as part of the record entry. Without having auditing turned on, is there a way to do determine this from the data dictionary tables and, if so, which ones. I'm a rather new DBA and not well versed in Oracle's data dictionary tables. All of my searching for keeps directing me to information about auditing. There's a simple way to set this up for future use. alter table my_table add ( row_create_date date default sysdate ) Obviously this will not work for old data, but may be useful in the near future for cleaning up data. And 30 days from now, all rows with a null value for this column will be 30+ days old. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist