Autonomous Database Now Lets You Export Data as JSON to Cloud Object Store
The DBMS_CLOUD package has been enhanced to allow exporting of data (by specifying a query) to a cloud object store as JSON. It supports all the Cloud Object Stores supported by Autonomous Database. It is possible to use an Oracle Cloud Infrastructure resource principal to access Oracle Cloud Infrastructure Object Store or Amazon Resource Names (ARNs) to access AWS Simple Storage Service (S3).
For more information about how to move data to object store as a JSON file use this link: https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/export-data-json.html#GUID-1058285D-677C-477E-A1CC-54ABA3E00B16