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.
See Move Data to Object Store as Oracle Data Pump Files Using EXPORT_DATA for details on exporting to cloud Object Store in Oracle Data Pump dump format.
- Export JSON Data to Cloud Object Storage
Shows the steps to export table data from your Autonomous Database to Cloud Object Storage as JSON data by specifying a query. - Export Data as CSV to Cloud Object Storage
Shows the steps to export table data from your Autonomous Database to Cloud Object Storage as CSV data by specifying a query. - Export Data as Parquet to Cloud Object Storage
Shows the steps to export table data from your Autonomous Database to Cloud Object Storage as Parquet data by specifying a query. - Export Data as XML to Cloud Object Storage
Shows the steps to export table data from your Autonomous Database to Cloud Object Storage as XML data by specifying a query. - File Naming for Text Output (CSV, JSON, Parquet, or XML)
Describes the output file naming usingDBMS_CLOUD.EXPORT_DATA
with CSV, JSON, Parquet, or XML text file output.