This article addresses how to run the Data Pump Export utility.
The Data Pump Export is accessed by going to Database | Export | Data Pump Export. The module itself consist of five export options at the top (Tables, Schemas, Tablespaces, Database, Transportable Tablespace Mode) and six parameter tabs (Items, Queris, Filters, Params, Files, Comments).
The Data Pump Export uses the Oracle expd.exe file. The minimum steps you need to take to use it are below.
1. Create a Directory Object. This is done on the server, so it may be neccessary to ask your DBA if there is one that you can use or create one for you. If you have rights to create Directory Objects, then create one yourself by going to the Schema Brower of Toad and accessing the Directory tab.
2. Once Directory Object is created, choose one of the five export types.
3. Under the Items tab, choose the item(s) to export by clicking on the "Add" button.
Note: This brings up the "Object Search" window. This window causes alot of confusion because many users think that this is where you choose the objects to export and proceed to click "OK." Then they notice that nothing shows up in the Items tab. Remember that this is the Object Search window. The check boxes are where you want to search. So, type in under the Search Term field what you want to search and check the places that you want to search. Then hit "OK." When the results come back, highlight the objects that you want to export and hit "OK." Note: Use CTRL + left click to choose more than one objects.
4. Under the Files tab, you must specify the following:
- The path to save your parameter file as .dat format
- Do the export or just create the parameter file
- The Directory Object which you created in step 1
- The dump file name
- The log file name
There are the minimum steps you need to run a Oracle export using exp.exe. For more info on other specific details, please consult your Oracle text.
