Date Stamp of the inserted/ Updated Record

Hi,

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

Thanks
Anurag

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

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

Logminer?

- Chris

In 8.0.5 database.

Quote:

---

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.

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