v$logmnr_contents, delete -> insert
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: v$logmnr_contents, delete -> insert

  1. #1
    Join Date
    Jun 2001

    Unhappy v$logmnr_contents, delete -> insert

    Dear All

    We have a small table into which data was inserted some time ago. This data has been deleted in error. I have run logminer and this has provided me with each delete statement. I was wondering if anyone out there had some kind of script that would derive an insert statement from each delete statement so I don't have to do this by hand 390 times! We don't have the archive logs that would have been created when the data was initially inserted (1+ months ago).

    Any suggestions much appreciated.



  2. #2
    Join Date
    Jun 2001

    Red face

    Ignore me. Just found a column in v$logmnr_contents called sql_undo, which has everything I need

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