Re: Determine row entry time?
From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 22 Feb 2001 21:15:40 GMT
Message-ID: <973vhs$jcj$1_at_crax.cesnet.cz>
Date: 22 Feb 2001 21:15:40 GMT
Message-ID: <973vhs$jcj$1_at_crax.cesnet.cz>
Mark McArthey <mcarthey_at_nospam.execpc.com> wrote:
> Is it possible to determine the time that a row was entered into a
> table without actually having a DATE field available as part of the
> table? To take that one step further, is it possible to see changes
> made to all tables for a specific user during a date range?
> Thanks much!
> Mark
It is not possible. Oracle doesnt store timestamp of creating record. In newer version of Oracle is posible to use log miner and then you will be able to say not so precisely time of inserting record into table.
Starous Received on Thu Feb 22 2001 - 22:15:40 CET