Restore Options (Advanced Options)

Restore Options (Advanced Options)

Use this dialog box to choose the import options for table restore:

Use DataPump if available

When selected, you can use the Data Pump export and import utility  (expdb/impdb) for exporting and importing data objects. If not selected, the older version of export and import (exp/imp) are used. Note that, stored procedures can be exported only if this option is selected.

Include triggers

Select to include all the triggers from the selected tables during the restore operation.

Include constraints

Select to include all the constraints on the selected tables during the restore operation.

Include indexes

Select to include all the indexes on the selected tables during the restore operation.

Include grants

Select to include all the object grants on the selected tables during the restore operation.

Include stored procedures

Select to include all the indexes on the selected tables during the restore operation.

Use additional export parameters

Select to include additional export parameters, such as COMPRESS or PARALLEL.

Import Options

Lists the options for importing the tables.

Do not Import

Select to export the table and leave it in the staging area.

Import to Source Database

Select to import the table to the source database.

Import to a Different Database

Select to import the table to a different database.

Select Import Database

Specifies the SID of the database to where the tables will be imported.

Select a Client

Select the client on which the import database resides.

Drop Table for Import

When selected, the existing tables will be deleted from the destination database before importing the tables.

Save As Script

Click to open the Save As Script dialog, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using qoperation execute command.

When you save an operation as a script, each option in the dialog will have a corresponding XML parameter in the script file. When executing the script, you can modify the value for any of these XML parameters as per need.

For more information on restores performed from the command line, see Command Line Interface for Oracle iDataAgent.