DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.