Inserting records to an oracle table with data from a similar table from another oracle database
Hi,
We had a problem recently where some (not all) of the records from one of our (production instance) tables got deleted. We have a copy of the deleted records on one of our 'test' instance which is another oracle database on a separate server which was created through data pump.
What would be the best, easiest and 'newbie' friendly way to get the record set from the test instance and insert it on the production table?
Our production db doesn't have flashback table enabled and as of the moment, I am not confident of restoring from a previous backup. The only way that I can think of is to get the missing rows from test and insert it on prod.
We had a problem recently where some (not all) of the records from one of our (production instance) tables got deleted. We have a copy of the deleted records on one of our 'test' instance which is another oracle database on a separate server which was created through data pump.
What would be the best, easiest and 'newbie' friendly way to get the record set from the test instance and insert it on the production table?
Our production db doesn't have flashback table enabled and as of the moment, I am not confident of restoring from a previous backup. The only way that I can think of is to get the missing rows from test and insert it on prod.
0