The two options that come to mind are: 1) Restore the data files you need individually. Scroll down to section 6.4.3.3. http://docs.oracle.com/cd/B19306_01/backup.102/b14192/recov004.htm#i1040443 2) Duplicate the source database to the target using DUPLICATE DATABASE, and exclude the tablespaces you don't wish to restore. http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm -Justin -- //www.freelists.org/webpage/oracle-l