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,

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Log Miner.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

Previous Topic: Global Temporary Tablespace
Next Topic: Update entire database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 18:29:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.