Move Data with Data Pump Export to Object Store

To move data from your Autonomous Data Warehouse database to other Oracle databases you can use Oracle Data Pump to directly export to your object store. Using this export method you use Oracle Data Pump to directly export to your object store. This export method is supported with Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.

See Move Data with Data Pump Export to an Autonomous Database Directory for details on the alternative export method to use with other supported cloud object stores.

To export data from an Autonomous Data Warehouse database to other Oracle databases, do the following:

  1. Use Data Pump Export to export from an Autonomous Data Warehouse database to Object Storage.

    There are differences depending on the version of Oracle Data Pump you use, Version 19.7 (or later) or Version 19.6 (and earlier):

  2. Download the dump files from the Object Storage service, run Data Pump Import with the dump files, and perform any required clean up such as removing the dump file set from Object Storage.

    See Download Dump Files, Run Data Pump Import, and Clean Up Object Store for details.