Re: Determine row entry time?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 22 Feb 2001 09:59:58 +0100
Message-ID: <f6l99t4p55qurlt10vve9r1p689rki57lh@4ax.com>

On Wed, 21 Feb 2001 16:07:11 -0600, 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

If you have lots of spare time, run in archivelog and want to use logminer (Oracle 8i and beyond) : yes

Adding a timestamp is a way better solution, as the overhead is zilch.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Feb 22 2001 - 02:59:58 CST