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
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
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?


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: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Log Miner.

Re: Recover table with deleted records [message #357980 is a reply to message #357659] Fri, 07 November 2008 08:14 Go to previous message
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: Sat Jul 22 07:47:47 CDT 2017

Total time taken to generate the page: 0.26734 seconds