Load JSON on Autonomous Database
The
PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION
provides support for loading JSON documents into SODA collections. The procedure DBMS_CLOUD.COPY_DATA
provides support for
loading JSON data into an existing table in Autonomous Database.
- About Loading JSON Documents
You load SODA collections into Autonomous Database using the PL/SQL procedureDBMS_CLOUD.COPY_COLLECTION
and you load JSON data into a table usingDBMS_CLOUD.COPY_DATA
. - Load a JSON File of Line-Delimited Documents into a Collection
For loading data from collections in the Cloud, you must first store your object storage credentials in your Autonomous Database and then use the procedureDBMS_CLOUD.COPY_COLLECTION
to load documents into a collection. - Load an Array of JSON Documents into a Collection
To load data from collections in the Cloud, you first store your object storage credentials in your Autonomous Database and then use PL/SQL procedureDBMS_CLOUD.COPY_COLLECTION
to load documents into a collection. This topic explains how to load documents to your database from a JSON array in a file. - Monitor and Troubleshoot COPY_COLLECTION Loads
All data load operations you perform using the PL/SQL package
are logged in the tablesDBMS_CLOUD
dba_load_operations
anduser_load_operations
. Use these tables to monitor loading withDBMS_CLOUD.COPY_COLLECTION
. - Textual JSON Objects That Represent Extended Scalar Values
Native binary JSON data (OSON format) extends the JSON language by adding scalar types, such as date, that correspond to SQL types and are not part of the JSON standard. Oracle Database also supports the use of textual JSON objects that represent JSON scalar values, including such nonstandard values. - Create Credentials and Copy JSON Data into an Existing Table
UseDBMS_CLOUD.COPY_DATA
to load JSON data in the cloud into a table.
Parent topic: Load Data from Files in the Cloud