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