From: jusungyang@yahoo.com (Jusung Yang)
Newsgroups: comp.databases.oracle
Subject: Re: get creation date of record?
Date: 8 Aug 2002 09:07:38 -0700
Organization: http://groups.google.com/
Lines: 22
Message-ID: <42ffa8fa.0208080807.2f368515@posting.google.com>
References: <5e909902.0208072352.24b3c792@posting.google.com>
NNTP-Posting-Host: 64.168.22.105
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028822859 2462 127.0.0.1 (8 Aug 2002 16:07:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 16:07:39 GMT


No. You can find out when an "object" was created, but not for each
individual record in a table. Imagine ORACLE having to keep this info
for millions and millions of records. Plus your question may be
inherently flawed. If there are duplidates in a table, you can not
"logically" ask ORACLE when the record was created. You will have to
go down to the "physical" level. The best you can do, if you don't
have your own auditing mechanism, is to search thru the redo logs.
With the help of LogMiner, you might be able to find what you are
looking for.



bpm13@gmx.net (Pat Buerki) wrote in message news:<5e909902.0208072352.24b3c792@posting.google.com>...
> Hi
> 
> I wonder if, and if yes, how to get the date, when a record was
> created. Does there exist a kind of 'hidden attribute' or something
> like that.
> Any help is highly appreciated.
> 
> tia
> Pat