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

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;