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.
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.
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
But for that I need to have the archive logs. Isnt there any other method.
Forum Rules