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.
Thanks
Austin