Including All Dependencies to the Dependent and Referenced Tables

When restoring tables, you can include recursive dependency relationship of all the dependent/referenced tables.

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.

Use the following steps to include all the dependent/referenced tables recursively:

1. Right-click the <Instance>, point to All Tasks and then click Browse and Restore.

2. Select Latest Backup check the Table View check box and click View Content.

3. Right-click the <table> and click Select All Dependent Tables Recursively to exclude all the dependent tables.

   Similarly, click Select All Referenced Tables Recursively to exclude all the referenced tables.

4. Click Recover All Selected.

   The Table Restore Options dialog box appears.

5. On the Table Restore tab, in the Staging Path box, type the location where the auxiliary instance will be created.

6. Click OK.