grasshopper_usa
asked on
How do you retrieve deleted data after a commit?
2 data records were deleted in sql and a commit was executed. These records need to be retrieved. How can I
restore them?
First time using experts exchange, please bear with me.
We are using oracle 8i, I have very little experience with
oracle administration and would need a detail step by step walk through if possible.
restore them?
First time using experts exchange, please bear with me.
We are using oracle 8i, I have very little experience with
oracle administration and would need a detail step by step walk through if possible.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The following document provides 15 database recovery scenarios - including this situation (scroll down to Scenario #8):
http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/installgen_win901_39_.html#recovery_scenarios
To summarize, if you have a database export available, then re-importing the data would generally be the quickest method.
David Simpson
www.dotcomsolutionsinc.net
http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/installgen_win901_39_.html#recovery_scenarios
To summarize, if you have a database export available, then re-importing the data would generally be the quickest method.
David Simpson
www.dotcomsolutionsinc.net
If you do, you can clone the database to a new server, recover it to a point in time before the deletion occurred (like one SCN just prior to the COMMIT statement for the delete), then copy those two rows from the clone back to the original database.
Andrew