I'm using Oracle an would like to make a partial copy (not duplicating all tablespaces) of my database using the SKIP feature of RMAN DUPLICATE.

The problem is that I got a partitioned table tab1 having the partition part1 on tablespace tbs1 and a second partition part2 on tablespace tbs2.

What I would like to do is to make a recovery/duplicate of my DB. I want to duplicate only the tablespace SYSTEM and the tablespace tbs1.

Will this be possible or will oracle have any problem because I do not include all partitions of tab1. Will there be any problem when RMAN will try to drop the not recoverd/duplicated tablespace tbs2 because it inlcudes some partitions of the table tab1?

If someone has any experience in this area I would be gratefull to get any feedback