Home » RDBMS Server » Server Administration » Recover table with deleted records (oracle 10g)
Recover table with deleted records [message #357653] Thu, 06 November 2008 02:55 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi,
I have a table in which the some records are deleted by developer by mistake. He has deleted records 1 day ago.

Now i want to recover those records.
My backup is at TAPE location.

What could be the possible solutions to recover table of only those deleted records?

Thanks,

Re: Recover table with deleted records [message #357659 is a reply to message #357653] Thu, 06 November 2008 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Log Miner.

Regards
Michel
Re: Recover table with deleted records [message #357980 is a reply to message #357659] Fri, 07 November 2008 08:14 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Restore the table from tape to another database, recover the missing records rom there and re-import into master database
Previous Topic: Global Temporary Tablespace
Next Topic: Update entire database
Goto Forum:
  


Current Time: Fri Dec 09 11:55:22 CST 2016

Total time taken to generate the page: 0.09511 seconds