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

EXPDP DATABASE

Description

Exports all physical files in a database.

Syntax

EXPDP DATABASE db_name LOCATION = 'directory';

Parameters

  • db_name

    Name of the database to be exported.

  • directory

    Directory for storing exported files.

Examples

-- The EXPDP DATABASE syntax 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.
gaussdb=# EXPDP DATABASE test LOCATION = '/data1/expdp/database';