Move Data with Data Pump Export to Object Store

To move data from Autonomous Databases to other Oracle databases you can use Oracle Data Pump. Using this export method you use Oracle Data Pump to directly export data 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 Autonomous Databases to other Oracle databases, do the following:

  1. Use Data Pump Export to export from your database to Object Storage.

    You have two options for setting the credential to access Object Store, depending on your Oracle Data Pump version:

  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.