6 Moving Data from Autonomous Database 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 an Autonomous Database to another Oracle database, use one of the following methods:

  • Use Oracle Data Pump to export the data 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.
  • Using Oracle GoldenGate Capture for Oracle Autonomous Database