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

To export data from an Autonomous AI 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 AI 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 AI Database.

Topics

• Export Data to Object Store as Text

  Use DBMS_CLOUD.EXPORT_DATA to export data as text from an Autonomous AI 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 AI Database Directory Oracle Data Pump offers very fast bulk data and metadata movement between Autonomous AI Database and other Oracle databases. To move data from an Autonomous AI Database to another Oracle database, use Oracle Data Pump to export to a directory on your Autonomous AI Database.

• Move Data with Data Pump Export to Object Store

  To move data from Autonomous AI 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 AI Database

  Using Oracle GoldenGate you can capture changes from an Oracle Autonomous AI Database and replicate to any target database or platform that Oracle GoldenGate supports, including another Oracle Autonomous AI Database.