RE: Determine Record Creation Date Without Audit Turned On

From: Tao Wang <>
Date: Wed, 18 Jun 2008 12:33:43 -0400
Message-ID: <>

You can try the pseudo column ora_rowscn and function scn_to_timestamp(ora_rowscn). But the function scn_to_timestamp seems to work for rows updated relatively recently.

-----Original Message-----

[] 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


The information contained in this email and any attachments may be privileged and/or confidential and protected from disclosure. It is intended solely for the use of the recipient(s) to whom it is addressed, or an employee or agent responsible for delivering this message to the intended recipient(s). You are hereby notified that any dissemination, distribution, copying or other use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by reply email and delete this email and all attachments from your system. Thank you.
-- Received on Wed Jun 18 2008 - 11:33:43 CDT

Original text of this message