Export Data to a Directory
DBMS_CLOUD.EXPORT_DATA
to export files to a
directory.
- Export Data as CSV to a Directory
Shows the steps to export table data from your Autonomous Database to a directory as CSV data by specifying a query. - Export Data as JSON a Directory
Shows the steps to export table data from your Autonomous Database to a directory as JSON data by specifying a query. - Export Data as XML to a Directory
Shows the steps to export table data from your Autonomous Database to Directory as XML data by specifying a query.
Parent topic: Export Data From Autonomous Database
Export Data as CSV to a Directory
Shows the steps to export table data from your Autonomous Database to a directory as CSV data by specifying a query.
Notes for exporting with DBMS_CLOUD.EXPORT_DATA
:
-
The
query
parameter that you supply can be an advanced query, if required, such as a query that includes joins or subqueries. -
Specify the
format
parameter with thecompression
option to compress the output files.
Parent topic: Export Data to a Directory
Export Data as JSON a Directory
Shows the steps to export table data from your Autonomous Database to a directory as JSON data by specifying a query.
Notes for exporting with DBMS_CLOUD.EXPORT_DATA
:
-
The
query
parameter that you supply can be an advanced query, if required, such as a query that includes joins or subqueries. -
Specify the
format
parameter with thecompression
option to compress the output files.
Parent topic: Export Data to a Directory
Export Data as XML to a Directory
Shows the steps to export table data from your Autonomous Database to Directory as XML data by specifying a query.
Notes for exporting with DBMS_CLOUD.EXPORT_DATA
:
-
The
query
parameter that you supply can be an advanced query, if required, such as a query that includes joins or subqueries. -
Specify the
format
parameter with thecompression
option to compress the output files.
Parent topic: Export Data to a Directory