I am looking for an option to restore the Oracle table space in the same server but different Database name. Please let me know if anyone has tested that before
Host Name : Server1
Source DB Name : DBNAME_1
Table Space : SYSAUX, SYSTEM , .....
Destination Server : Server1
Destination DB Name : DBNAME_2
Also is the Duplicate DB option will work ( I have never tested and I believe it is for the entire DB not for selected Table space )