Updated on 2024-05-07 GMT+08:00

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.

Example

expdp database test location = '/data1/expdp/database';