Export tables with their triggers, indexes, FK constraints, etc.

Download dump file Download job definition

In Table mode Data Pump operates on tables located within one schema (in Oracle 11g/R2 one schema restriction has been relaxed). By default, table and all their subordinate objects are processed.

This tutorial shows how to export two tables EMP and DEPT belonging to user SCOTT along with their accompanying objects.

Tips:

• Without NAME_LIST filter, all tables in selected schema are exported.
• If SHEMA_LIST filter not present, Data Pump processes tables in schema of the user launched the job.
• Subsequently, omitting both filters exports all tables in current schema.

Step 1/4: Selecting Operation and Mode

Since we are interested only in tables which located within the same schema, TABLE mode EXPORT would be our natural choice.

Step 2/4: Specifying output file

Here we type name of the output dump file, select DIRECTORY object, and add the file to dump set. Note how AlderPump displayed file system path on database server machine to which Directory object is pointing. Should file already exist, export would fail unless we explicitly request to replace old file by checking Reuse flag. By default dump files are never overwritten, while log and sql files are always overwritten. We could also specify maximum file size, this is useful when specifying multiple files or using substitution variable %U.

Step 3/4: Selecting objects to be exported

Specifying which objects should be exported occurs on Objects Filter page. Data Pump recognizes rich set of filter types, and AlderPump supports them all. In this tutorial, however, we will take a shortcut and use Objects Picker dialog which displays database schemas and objects and allows select them interactively. We marked tables of interest and dragged them onto 'Add objects' hotspot. AlderPump then added tables to the list. It has also figured their schema and added it to selection list. After all tables were selected, we close Objects Picker and AlderPump merges selected objects into list of filters. Expert users can add filters manually without invoking Objects Picker.

Step 4/4: Running export

On creation, jobs enter DEFINING stage. At this stage they are ready to run, but still can be modified or cancelled. We start created job and monitor its progress in the Log window. If you ever ran expdp, you've probably noticed that AlderPump displays exactly same messages. That is because they both communicate with Oracle Data Pump engine which runs commands and reports statuses. In AlderPump, running job can be paused or cancelled with click of a button, but we don't do that here and just wait for the job to complete.

Occasionally you may get error message when defining job:

It means the output file already exist. Either delete the file on database server, or check "Reuse" flag on File panel for Data Pump to override it.