Date Stamp of the inserted/ Updated Record

[anuragmin]

Hi,

Is there any way I can find the date stamp when a particular record was first inserted and last updated.

Thanks
Anurag

[chrisrlong]

Two fields: Inserted_TS and Updated_TS.

Populate the Inserted_TS in an insert trigger and set the Updated_ts in an update trigger.

Is this what you wanted?

- Chris

[anuragmin]

Hi,

This will take care of the future inserts and updates. Is there any way I can find out the date stamp for already inserted records.

Thanks
Anurag

[chrisrlong]

Logminer?

- Chris

[anuragmin]

In 8.0.5 database.

[jmodic]

Originally posted by anuragmin
In 8.0.5 database.

Still logminer. You'll need 8i instance, but you'll be able to analyze 8.0.5 archived logs.

[anuragmin]

But for that I need to have the archive logs. Isnt there any other method.