RE: Determine Record Creation Date Without Audit Turned On
- From: "Langston, Chris" <Chris.Langston@xxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Thu, 19 Jun 2008 13:40:27 -0500
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
Other related posts:
