DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TIME OF UPDATE/INSERT

  1. 03-18-2002, 03:27 PM #1
    ndisang
    ndisang is offline Member
    Join Date
    Sep 2001
    Posts
    200
    I truncated a table at 8am. I want to recover to a PIT. But I want to find out at what time the first row was inserted after the trucate to time my recovery.
    Thanks

    Life is what is happening today while you were planning tomorrow.
    Reply With Quote Reply With Quote
  2. 03-18-2002, 03:33 PM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You might be able to see by running the logminer, utility

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  3. 03-19-2002, 01:30 PM #3
    ndisang
    ndisang is offline Member
    Join Date
    Sep 2001
    Posts
    200
    You can run the logminer stuff but that takes to long and my logs are huge. I know there's simple SQL, invloving dual table but i just can't remember it. It is select a column of something like "upt_dm_tm". I'm just hoping to jog someone's memory.
    Thnks
    Life is what is happening today while you were planning tomorrow.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width