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

IMPDP TABLE

Description

Specifies the execution phase of importing a table.

Syntax

IMPDP TABLE [AS table_name] SOURCE = 'directory' OWNER = user;

Parameters

  • table_name

    Name of the new table after the import. If this parameter is not specified, the original table name is retained after the import.

  • directory

    Data source directory of the imported table.

  • user

    Owner of the imported table.

Examples

-- The IMPDP TABLE 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 advised not to directly call the syntax.
gaussdb=# IMPDP TABLE SOURCE = '/data1/impdp/table0' OWNER=admin;