Restore single table
759056Mar 9 2010 — edited Mar 12 2010I've accidentally truncated a table for the wrong schema and I need to get the data back. I realize this isn't an easy task with rman, but I'm looking for advice for the best method.
I am running Oracle Standard Edition 11.1.0.6.0 on Linux. A cold backup of this database is created every week with rman. It is not in archivelog mode, since it would generate too many log files and all the changes are fairly easy to replicate. The only method I know of is to restore the entire database on another machine, then export the table/data from the restored database and import it into the truncated table. This will take quite a bit of time (a few or several days), and seems to contain a lot of unnecessary work for the computers involved. The table was only a few 100 MB, and the DB is 1TB+.
Is there any way to restore just the tablespace with the truncated table on a new server? Can this somehow be done in another database instance on the same computer? If I can restore just one tablespace, but have to do it on a different computer, can I avoid having to transfer the entire rman backup to the new server? Is there anything like flashback that will help me on Oracle Standard Edition? Are there any other suggestions for restoring the one table more quickly?