Home » RDBMS Server » Backup & Recovery » how to recover data after it is deleted (Oracle 9i)
how to recover data after it is deleted [message #332278] Tue, 08 July 2008 01:37 Go to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
Can any one please tell me . how to recover data after it is deleted and committed in oracle 9i . its very urgent

thanks in anticipation
Re: how to recover data after it is deleted [message #332294 is a reply to message #332278] Tue, 08 July 2008 02:16 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try flashback query, if data are still in undo segments.
Otherwise use LogMiner but you can't do it in urgent way, you have to think.

Regards
Michel
Previous Topic: ORA-01595: error freeing extent (2) of rollback segment (6))
Next Topic: bakup
Goto Forum:
  


Current Time: Fri Dec 02 16:19:25 CST 2016

Total time taken to generate the page: 0.19625 seconds