6 Moving Data from Autonomous Data Warehouse to Other Oracle Databases

Oracle Data Pump offers very fast bulk data and metadata movement between Autonomous Database and other Oracle databases.

To export data from your Autonomous Data Warehouse database to other Oracle databases, use one of the following methods:

  • Use Oracle Data Pump to export the data from your Autonomous Data Warehouse database to a directory on your database, and then move the data from the directory to your cloud object store.

  • Use Oracle Data Pump to export the data to your cloud object store directly. This method is only supported with Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.

  • Use the procedure DBMS_CLOUD.EXPORT_DATA This method is only supported with Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.