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.
Report message to a moderator
Send a private message to this user
- 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: 24859
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member

1, 3

Regards
Michel