Re: get creation date of record?

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_at_gmx.net (Pat Buerki) wrote in message news:<5e909902.0208072352.24b3c792_at_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
Received on Thu Aug 08 2002 - 18:07:38 CEST