Do you have a guide or a link to how to do this? I have only ever done this with RMAN. From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx] Sent: Tuesday, September 08, 2009 10:49 AM To: Josh Collier Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: restore only one tablespace from a cold backup to another database? Josh, not only one TS, but SYSTEM, UNDO and the particular TS ( + redos) should be possible to bring your auxiliary DB up (setting all other datafiles offline). These should be small enough. Am I missing anything? Martin 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.