RE: Determine Record Creation Date Without Audit Turned On

  • From: "Langston, Chris" <Chris.Langston@xxxxxx>
  • To: "David Litchfield" <david@xxxxxxxxxxxxxxxxxxxx>, "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Fri, 20 Jun 2008 10:16:31 -0500

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

Other related posts: