6 Load JSON

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 JSON Database using the PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION and you load JSON data into a table using DBMS_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 procedure DBMS_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 procedure DBMS_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.
• Create Credentials and Copy JSON Data into an Existing Table
  Use DBMS_CLOUD.COPY_DATA to load JSON data in the cloud into a table.
• Monitor and Troubleshoot COPY_COLLECTION Loads
  All data load operations you perform using the PL/SQL package DBMS_CLOUD are logged in the tables dba_load_operations and user_load_operations. Use these tables to monitor loading with DBMS_CLOUD.COPY_COLLECTION.
• Import SODA Collection Data Using Oracle Data Pump Version 19.6 or Later
  Shows the steps to import SODA collections into Autonomous Database with Oracle Data Pump.
• 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.