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 (expdp/impdp) for exporting and importing data objects. If not selected, the older version of export and import (exp/imp) is used. 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.
For more information on restores performed from the command line, see Command Line Interface for Oracle iDataAgent.