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. See Use Oracle Data Pump to Export Data to Object Store for details.

  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.