8 Using Data Pump

You can import and export data and metadata using Data Pump. Data Pump is made available in SQLcl using the PL/SQL package, DBMS_DATAPUMP.

You can do the following:

  • Export one or more schemas.

  • Import one or more schemas with the remap schema option.

  • Use DATAPUMP export and import for Oracle Database and Oracle Autonomous Database Cloud Services.

  • Use database directory or Oracle Object Store for dump files, which can be optionally encrypted.

  • Perform parallel processing of dump files.

  • Filter objects by object types or names.

  • Use the SET DATAPUMP command to set defaults and save them with the STORE command.

  • Use the Cloud Storage feature to put or get from the database directory.

Topics