| To recover deleted rows [message #357673] |
Thu, 06 November 2008 03:54  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
