Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ SQL Reference/ SQL Syntax/ I/ IMPDP RECOVER
Updated on 2025-05-29 GMT+08:00
View PDF
Share

IMPDP RECOVER

Description

Specifies the execution phase of importing a database.

Syntax

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

Parameters

  • directory: data source directory of the imported database.
  • user: owner of the imported database.
  • LOCAL: If this column is specified, data is imported to the original cluster. If this column is not specified, data is imported to a new cluster.

Examples

-- The IMPDP DATABASE RECOVER 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 DATABASE RECOVER SOURCE = '/data1/impdp/database' OWNER=admin;
Parent topic: I