This is pretty much the recommended procedure. For a detailed walkthrough,
see 'Recovering a Dropped Table from a Full Database Backup' - doc ID 96197.1
at metalink.oracle.com.

HTH,
-Chris

-----Original Message-----
From: Olson, David
Sent: Tuesday, April 30, 2002 10:56 AM
To: LazyDBA.com Discussion
Subject: Database Recover - Tablespace from a Cold backup

Due to a programming issue, I need to restore a table from a cold backup. I could restore the whole database, close to 50G, but it will take hours to get it off of tape. I'm looking for ways to restore the need tablespace with out having to restore the whole database, if that's possible.
Here is what I was thinking of trying:
Restore the datafiles for the System, Rollback, temp and the needed tablespace.
Create a new databse with the restored files
export the needed table.
Does this sound like it will work? Or do I need to restore the whole database?
Thanks,
Dave
Oracle LazyDBA home page