Re: Determine row entry time?

Group,

I agree with Sybrand.
Have managed several systems that tried to do detailed auditing, most of them failed to satisfy user in the end.
Q : what are the exact requirements ? why do it ?

Some solutions I see :

• if really important : use trigger + history table with timestamp+additional info.
• include timestamp + last user modified into the table, low overhead really.
• use the audit options (will give you primitive, but complete overview, good for 90% of cases, and sometimes extremely interesting

Combination of the above may also work for you.

Most important : Purge the audited data.

Open for other suggestions,

Regards,
PdV.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:f6l99t4p55qurlt10vve9r1p689rki57lh_at_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 - 07:04:13 CST