EXPDP DATABASE

Function

EXPDP DATABASE exports all physical files in a database.

Syntax

EXPDP DATABASE db_name LOCATION = 'directory';

Parameter Description

• 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 directly call the syntax, an error message may be displayed, indicating that the directory does not exist. Therefore, you are not advised to directly call the syntax.
gaussdb=# EXPDP DATABASE test LOCATION = '/data1/expdp/database';