Database Reference
In-Depth Information
Similarly, Figure
8-2
displays the architectural components of a Data Pump import job. The main difference
between export and import is the direction in which the data flow. Export writes data out of the database, and import
brings information into the database. Refer back to these diagrams as you work through Data Pump examples and
concepts throughout this chapter.
Figure 8-2.
Data Pump import job components
For each Data Pump job, you must ensure that you have access to a directory object. The basics of exporting and
importing are described in the next few sections.
■
Because Data pump internally uses pL/SQL to perform its work, there needs to be some memory available in the
shared pool to hold the pL/SQL packages. If there is not enough room in the shared pool, Data pump will throw an
ORA-04031: unable to allocate bytes of shared memory...
error and abort. If you receive this error, set the
database parameter ShareD_pOOL_SIZe to at least 50m. See mOS note 396940.1 for further details.
Tip
Getting Started
Now that you have an understanding of the Data Pump architecture, next is a simple example showing the required
export setup steps for exporting a table, dropping the table, and then reimporting the table back into the database.
This will lay the foundation for all other Data Pump tasks covered in this chapter.
