Home » RDBMS Server » Backup & Recovery » To recover deleted rows (Oracle 10g , Windows XP)
To recover deleted rows [message #357673] Thu, 06 November 2008 03:54 Go to next message
Messages: 59
Registered: March 2008
Hi ,
Suppose I deleted all rows of a table and committed it , say at 2PM.
How can I recover them so that it does not affect other connected users?
1. Use TSPITR ( table space point in time recovery)

2.Use conventional incremental export and then import (I personally think this is not correct , as doing an export now will not contain the rows ) .

3.Use flashback query to retrieve rows deleted

Please suggested two out of these there.
Re: To recover deleted rows [message #357695 is a reply to message #357673] Thu, 06 November 2008 05:01 Go to previous message
Michel Cadot
Messages: 63937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1, 3

Previous Topic: Sys Admin needs Oracle 10g r2 backup to DLT tape solution
Next Topic: Restore one schema with RMAN
Goto Forum:

Current Time: Thu Oct 27 20:16:05 CDT 2016

Total time taken to generate the page: 0.08660 seconds