Getting Started with Data Pump Export (expdp)

Data Pump Export (expdp)

The expdp command is part of Oracle’s Data Pump utilities, designed to efficiently export and import database objects. It supports parallel processing and allows you to export data in various formats, making it an essential tool for database administrators.

Key Parameters

• tables: Specifies which tables to export.
• schemas: Exports all objects in a specified schema.
• query: Allows for exporting a subset of data based on specific criteria.

Step 1: Create a Directory Object

Before executing an export, you must create a directory object that points to a filesystem directory where the dump files will be stored.

SQL> CREATE OR REPLACE DIRECTORY expbkp AS '/u01/expdp';
Directory created.

Step 2: Grant Permissions

Grant the necessary permissions on the directory to the user performing the export:

SQL> GRANT READ, WRITE ON DIRECTORY expbkp TO discovery;
Grant succeeded.