When you browse using the table view, you can also view the dependent and referenced tables associated with the tables selected for the restore.
Dependent tables are the parent tables (containing the primary key) that the selected table (containing the foreign key) depends upon. Similarly, Referenced tables are the child tables (containing the foreign key) that references the selected table (containing the primary key).
Best Practice: Use the Oracle catalog when you perform a table-level restore on Oracle 11g or a more recent version. The restore needs the catalog in order to skip Oracle TTS failures that happen when the target connection occurs.
By default, all the dependent and referenced tables will be included in the restore operation.
Procedure
-
From the CommCell Browser, expand Client Computers > client > Oracle RAC.
-
Right-click the instance, point to All Tasks and then click Browse and Restore.
-
Select Latest Backup check the Table View check box and click View Content.
-
Right-click the <table> and click Select All Dependent Tables to exclude all the dependent tables.
Click Select All Referenced Tables to exclude all the referenced tables.
-
Click Recover All Selected.
-
On the Table Restore Options dialog box, navigate to the Table Restore tab.
- In the Staging Path box, type the location where the auxiliary instance will be created.
-
Click OK.