HI All,
There was a upload performed in our production database couple of weeks back, and we have noticed that it has deleted certain related data (in thousands) from other tables. We would like restore the deleted records in to the tables with data from a backup DB that we had before the upload.
Could someone please suggest what is the best way to restore the deleted data in these tables. There are around 5 tables that needs to be restored and couple of them have more than a million records, so we are finding it hard to compare the prod DB and the backup DB to determine what was deleted and how to insert it back.
I was wondering if Is there a way that we can export the tables from the backup DB, and import it into our prod DB, and during import somehow skip the data which is already existing in the target table. (Based on a unique ID column). If this is a possibility we would effectively be putting back whatever was deleted as a result of upload.
We are currently using Oracle Database 11g Enterprise Edition.
I would be very thankful to any pointers in this regard.
Thanks
AK