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

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 13:50:01 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.