6 Exporting Data from Autonomous Database to Object Store or to Other Oracle Databases

To export data from an Autonomous 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 Cloud Object Storage.

  • Use Oracle Data Pump to export the data to Cloud Object Storage 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 to export data to your Cloud Object Store as Oracle Data Pump dump files, by specifying a query. 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 to export data to your Cloud Object Store as text, by specifying a query. This export method supports exporting data as CSV, JSON, or XML files.

    This export method supports all the Cloud Object Stores supported by Autonomous Database, and you can use an Oracle Cloud Infrastructure resource principal to access your Oracle Cloud Infrastructure Object Store or Amazon Resource Names (ARNs) to access AWS Simple Storage Service (S3).

  • Use Oracle GoldenGate Capture for Oracle Autonomous Database.