Updated on 2025-05-29 GMT+08:00

EXPDP PLUGGABLE DATABASE

Description

Exports all physical files in a PDB.

EXPDP PLUGGABLE DATABASE is used for fine-grained backup and restoration and is called by the backup and restoration tool. If you call it directly, the error message "ERROR: Only auxdb is allowed to execute expdp cmd." is displayed.

Syntax

EXPDP PLUGGABLE DATABASE LOCATION = 'directory';

Parameters

  • directory

    Directory for storing exported files.

Examples

  • Export a PDB.
    --Create an export directory.
    mkdir /data1/expdp/my_pdb
    
    -- Connect to the PDB and perform the export operation.
    gaussdb=# \c my_pdb;
    my_pdb=# EXPDP PLUGGABLE DATABASE LOCATION = '/data1/expdp/my_pdb';