Online Documentation for Data Pump for Oracle

Step 1 - Setting connection properties


At Step 1 of the wizard you should set the source and the target database connection properties.

 

Please note that you need to have sufficient privileges to be able to write to the destination database on Oracle server.

 

Note: To establish connection to the source database, it is necessary to use additional software, namely data sources (OLE DB Providers and ODBC Drivers) which are distributed by DBMS developing companies and third-party developers. EMS Data Pump processes information received from the data source. The utility itself extracts neither data nor metadata from the source database. Therefore the functionality of Data Pump may be partially limited by the abilities of data source being used.

 

Source database connection properties

 

In order to set the source database connection properties, use Data Link Properties builder or select an initialization string from the list of previously built ones. To call the Data Link Properties dialog, press the Build button.

 

Step 1 - Setting connection properties

 

 

Target database connection properties

Oracle home

Specify your Oracle Home storage for this connection.

 

Connect as

Select the type of connection to be established: Normal (by default), SYSDBA, SYSOPER.

 

Authentication type

Specify the type of authentication to be used for the connection: Windows or Server authentication.

 

If Server has been selected as the authentication type, you should also provide authorization settings: User name and Password.

The default superuser name is 'SYS' (for Oracle 9.0 and higher) and the default password is 'change_on_install'.

 

Optimize goal

Use the drop-down list to establish the default behavior for choosing an optimization approach for the instance:

Unchanged

Select this value to apply the approach which is currently used by the optimizer.

FirstRows

If this value is selected, the optimizer uses a mix of cost and heuristics to find the best plan for fast delivery of the first few rows.

AllRows

If this value is selected, the optimizer uses a cost-based approach for all SQL statements in the session regardless of the presence of statistics and optimizes with a goal of best throughput (minimum resource use to complete the entire statement).

Choose

This parameter value is not supported any more.

Rule

This parameter value is not supported any more.

 

Database

Use the drop-down list to select the database to pump data into (the drop-down list contains databases currently specified in the TNS file).

Note: If no database are registered in Oracle Client (DB list is empty in this case), then you need to add registration info manually.

 

If you are using the EMS SQL Management Studio for Oracle version of Data Pump for Oracle then the Select registered database button is available. Click this button to pick a database already registered in the EMS SQL Management Studio in the Select Host or Database dialog.

 

 

 

Tunneling settings

 

To setup the connection via SSH tunnel, input the following values in the corresponding fields:

  • SSH host name is the name of the host where SSH server is running
  • SSH port indicates the port where SSH server is activated
  • SSH user name stands for the user on the machine where SSH server is running (Note: it is a Linux/Windows user, not a user of Oracle server)
  • SSH password is the Linux/Windows user password

 

For details see SSH tunneling options.

 

Step 1 - SSH tunneling options

 

 

When you are done, click the Next button to proceed to the selecting source schemas step of the wizard.