Date Stamp of the inserted/ Updated Record
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Date Stamp of the inserted/ Updated Record

  1. #1
    Join Date
    Sep 2000
    Posts
    362

    Unhappy

    Hi,

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

    Thanks
    Anurag

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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

  3. #3
    Join Date
    Sep 2000
    Posts
    362
    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

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Logminer?

    - Chris

  5. #5
    Join Date
    Sep 2000
    Posts
    362
    In 8.0.5 database.

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  7. #7
    Join Date
    Sep 2000
    Posts
    362
    But for that I need to have the archive logs. Isnt there any other method.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width