RE: Determine Record Creation Date Without Audit Turned On

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <Chris.Langston@xxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 18 Jun 2008 15:02:07 -0400

Dan, Patrick, and Tao have made useful suggestions. If none of those work
out for you and you are within range of the time in question, you could do a
set of flashback queries into a table containing just the table in
questions's PK (not as the PK) and current query's as of time. Then if a
given PK (original table) first appears in the time window to be deleted
you're set.

You might start with a broad grain of time, then use a very fine grain for
just the candidates. The actual data would determine how fine a grain you
would need to absolutely identify a row as being created within some window
of time.

Good luck!


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Langston, Chris
Sent: Wednesday, June 18, 2008 10:45 AM
To: oracle-l
Subject: Determine Record Creation Date Without Audit Turned On


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. 

The primary DBA for the application is on vacation for the rest of the
month and I don't know that much about the application.

Any direction or source of documentation that would explain this will be
much appreciated. 

Chris Langston



Other related posts: