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

• Prerequisites

  For details about how to create and open a PDB, see Examples in ALTER PLUGGABLE DATABASE.

• 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';