Restore table to another location from large tera bytes of database in oracle

Restore table to another location from large tera bytes of database in oracle

Step 1.

Find the table data in which tablespace it belong.

Step 2.

Create new database on another server.

Step 3.

Restored the tablespace  system,undo ,sysaux  and with tablespace which having data.

Restore tablespace system,undo,sysaux , app_data_tx;

Step 4.

Recover the database with skip option of other tablespace which is present in the database.

Recover database skip .......(all other tablespace which not needed)

Step 5.

startup the database

step 6.

alter database open resetlog.