What are the requirements for the Data Pump Wizard? (4280112)

Users are not able to run the Data Pump Wizard due to missing requirements. It is disabled or grayed out.

REQUIREMENTS:

1. You need a 10g Oracle Database. Data Pump is a unique feature to Oracle 10g.

2. Make sure you are connected using the Oracle 10g client. You can select to connect to your 10g client by selecting it from the "Connect using" drop down menu in the connection window.

3. You must have IMPDP.exe and EXPDP.exe in your Oracle bin.

4. Make sure you create a Directory Object for the Data Pump to dump files to. The Data Pump will not run unless you create your directory object first. A Directory Object can be created in TOAD if you have the right module. Otherwise, you can use the CREATE DIRECTORY command in Oracle. Consult your Oracle text for details.

Note: The above is meant as a guide line to address Data Pump requirements. Please consult your Oracle text for a more thorough study of the Data Pump. TOAD simplifies the Data Pump import/ export process via a Wizard. Please consult Help | Contents concerning the Data Pump Wizard.

--------------------------------------------------------------------

Other Information on the Data Pump Wizard:

Note: This Toad feature is only available in the commercial version of Toad in either the Professional Edition or with the optional DB Admin Module.

The Oracle data pump is an import/export utility added in Oracle 10g. It is significantly faster and more efficient at loading large volumes of data than the standard import/export utilities.

Because data pump client processes can detach from a session running on a server, you can close the import/export execution window without killing the job. The import/export will continue.

The data pump engine generates files that are incompatible with the old import/export utilities. This also means that the Toad Export File Browser cannot be used to open or review data pump generated export files.

Data Pump Requirements:

You must have read/write permissions to the export directory to use the data pump. Local directories must be shared, have read/write permissions and be indicated by the network path. By default, the Data Pump parameter file is stored in the Toad installation directory (C:\Program Files\Quest Software\Toad for Oracle).

In addition, you must have the import/export utilities in your client Oracle bin directory. Some 10g installations may not automatically install these utilities. The utilities required are:

IMPDP.EXE is the Data Pump client import utility

EXPDP.EXE is the Data Pump client utility

Note: These utilities are not the same as the old import/export utilities. If you need to import data from an older version of Oracle, you will need the old utilities. (See Import Utility wizard and Export Utility wizard.)

The paths for these utilities are stored in the Toad.ini file. You can view and change them from View | Toad Options | Executables. If the Import/Export Utility Wizard is opened and no path has been specified for the export utility, Toad will search for the path and enter it automatically, if it exists.

--------------------------------------------------------------------