Re: recover of single data object in oracle

From: Martin Rapier <M.Rapier_at_shef.ac.uk>
Date: 1 Oct 1998 13:34:27 GMT
Message-ID: <6v00d3$i7h$2@bignews.shef.ac.uk>

In article <360E6D66.4E32B674_at_reddogg.ne.mediaone.net>, chris_at_reddogg.ne.mediaone.net says...
>
>Assuming you haven't exported the table, and you only have the cold backup,
I'd
>restore the entire backup onto some scratch disks, start up the restored
>database, export just that table, then import it into the original instance.

This approach is outlined in more detail in an Oracle White Paper - I got it off OCIS, but I guess the awful MetaLink will have it somewhere.

I did it for real a couple of years ago, and be warned it is a non trivial task if you are only able to restore part of your backup onto your recovery machine.

Cheers
Martin

--
Martin Rapier, Database Administrator
Corporate Information & Computing Services. University of Sheffield Tel 0114 222 1137 The opinions expressed here may be those of my employer, or they may not. http://rhino.shef.ac.uk:3001/mr-home/ Received on Thu Oct 01 1998 - 08:34:27 CDT