Updated on 2024-06-03 GMT+08:00

IMPDP TABLE PREPARE

Function

IMPDP TABLE PREPARE specifies the preparation phase for importing a table.

Syntax

IMPDP TABLE PREPARE SOURCE = 'directory' OWNER = user;

Parameter Description

  • directory: data source directory of the imported table.
  • user: owner of the imported table.

Examples

-- The IMPDP TABLE PREPARE 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=# IMPDP TABLE PREPARE SOURCE = '/data1/impdp/table0' OWNER=admin;