Re: Determine Record Creation Date Without Audit Turned On
Date: Thu, 19 Jun 2008 09:31:28 -0700
Message-ID: <bf46380806190931g773af600ua659ffcfe9a03dc5@mail.gmail.com>
On Wed, Jun 18, 2008 at 7:44 AM, Langston, Chris <Chris.Langston_at_aa.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 19 2008 - 11:31:28 CDT