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

EXPDP TABLE

Function

EXPDP TABLE exports all table-related index, sequence, partition, toast, and toast index files.

Syntax

EXPDP TABLE table_name LOCATION = 'directory';

Parameter Description

  • table_name: name of the table to be exported.
  • directory: directory for storing exported files.

Example

expdp table test_t location = '/data1/expdp/table0';