During table restores, the tables are exported from the auxiliary instance to the destination client and later imported to the target database. By default, the following data objects are exported along with the tables:
-
Triggers
-
Constraints
-
Indexes
-
Grants
However, the stored procedures associated with the selected tables are not exported by default. Use the following steps to export the stored procedures and additional export parameters, such as (COMPRESS or PARALLEL):
Note
Stored procedures are restored from the Schema level. Schema is the collection of data objects created by the user to contain or reference their data. Hence, if one of the table within the schema is selected for restore, all the stored procedures for that schema will also get restored.
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.
When exporting the tables, the datapump export utility is used if it is supported by the Oracle application. The datapump utility facilitates the export of stored procedures. In oracle versions that do not support datapump export utility, you will not be able to include stored procedures during export.
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.
-
Select the tables and click Recover All Selected.
-
On the Table Restore Options dialog box, navigate to the Table Restore tab. Then in the Staging Path box, type the location where the auxiliary instance will be created.
-
On the Table Restore Options dialog box, navigate to the Advanced Options tab.
-
Select the Include Stored Procedures option.
-
Select the Use additional export parameters check box and type the parameters to be exported.
-
-
Click OK.