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
oracle_me
Messages: 59
Registered: March 2008
Member
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: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1, 3

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


Current Time: Tue Dec 06 06:35:47 CST 2016

Total time taken to generate the page: 0.12142 seconds