Is it possible to restore a table from an RMAN backup to a different database on a different server?
We have an RMAN full backup(level 0) of our production database.In this backup is a massive partitioned table that I would like to restore to the DEV database (on a different server). The schema and table name will be the same but the database names are different.
Is what I have explained possible?
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
OS: AIX 7100-03
Please advise and (if possible) provide and example of the RMAN code as a guideline.
Muchly appreciated and thanks in advance.
Andre'