Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-3.x)/ SQL Reference/ SQL Syntax/ IMPDP DATABASE CREATE
Updated on 2025-08-19 GMT+08:00
View PDF

IMPDP DATABASE CREATE

Function

IMPDP DATABASE CREATE specifies the preparation phase for importing a database.

Syntax

IMPDP DATABASE [db_name] CREATE SOURCE = 'directory' OWNER = user [LOCAL];

Parameter Description

  • db_name: name of the new database after the import. If this parameter is not specified, the original database name is retained after the import.
  • directory: data source directory of the imported database.
  • user: owner of the imported database.
  • LOCAL: If this field is specified, data is imported to the original cluster. If this field is not specified, data is imported to a new cluster.

Example

impdp database test create source = '/data1/impdp/database' owner=admin;
Parent topic: SQL Syntax