restore only one tablespace from a cold backup to another database?

  • From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 8 Sep 2009 10:43:47 -0700

All,

I am not convinced this is possible. I have a consistent cold backup, however 
it is very large and I don't have the space to copy the entire thing to a dev 
box. Is it possible to restore only one tablespace from this cold backup to an 
auxiliary database? This is not RMAN. It's a traditional cold backup.

Thanks for your time,

Josh C.

Other related posts: