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:

• Export to Cloud Object Store:

  • 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, Parquet, or XML files.

    This export method supports all the Cloud Object Stores supported by Autonomous Database.

  • Use Oracle Data Pump to export 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.

• Export to a directory:

  • Use the procedure DBMS_CLOUD.EXPORT_DATA to export data to a directory as text by specifying a query. This export method supports exporting data as CSV, JSON, Parquet, or XML files.

  • Use Oracle Data Pump to export data to a directory.

• Use Oracle GoldenGate Capture for Oracle Autonomous Database.

Topics

• Export Data to Object Store as Text
  Use DBMS_CLOUD.EXPORT_DATA to export data as text from an Autonomous Database to cloud Object Store. The text format export options are CSV, JSON, Parquet, or XML.
• Export Data to a Directory
  Use DBMS_CLOUD.EXPORT_DATA to export files to a directory.
• Move Data with Data Pump Export to an Autonomous Database Directory
  Oracle Data Pump offers very fast bulk data and metadata movement between Autonomous Database and other Oracle databases. To move data from an Autonomous Database to another Oracle database, use Oracle Data Pump to export to a directory on your Autonomous Database.
• 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.
• Move Data to Object Store as Oracle Data Pump Files Using EXPORT_DATA
  You can export data to Oracle Data Pump dump files by specifying a query.
• Download Dump Files, Run Data Pump Import, and Clean Up Object Store
  If required, download the dump files from Cloud Object Store and use Oracle Data Pump Import to import the dump file set to the target database. Then perform any required clean up.
• Access Log Files for Data Pump Export
  The log files for Data Pump Export operations are stored in the directory you specify with the data pump directory parameter.
• Oracle GoldenGate Capture for Oracle Autonomous Database
  Using Oracle GoldenGate you can capture changes from an Oracle Autonomous Database and replicate to any target database or platform that Oracle GoldenGate supports, including another Oracle Autonomous Database.