This can be used to recover the data in individual tables, possibly after a table has been dropped, for example. The tablespace containing the table is restored to an auxiliary instance, after which the data can be manually copied back to the original instance.
Note: Although the tablespace point in time recovery (TSPITR) initially restores the tablespace to an auxiliary instance, it also recovers the tablespace by transporting it back to the original instance.
See Oracle Metalink Document #228257.1 RMAN "Duplicate Database" Feature in Oracle 9i and Oracle 10g.
Home > Computers > Databases > Oracle > Recovery > Tablespace > Tablespace
Viewing mobile website page. Switch to WML or Full HTML