About Loading JSON Documents

You load SODA collections into Autonomous AI Database using the PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION and you load JSON data into a table using DBMS_CLOUD.COPY_DATA.

• DBMS_CLOUD.COPY_COLLECTION supports the following typical document loading procedures:

  • Loading line-delimited JSON into a collection. See Load a JSON File of Line-Delimited Documents into a Collection for this procedure.

  • Loading an array of JSON documents into a collection. See Load an Array of JSON Documents into a Collection for this procedure.

• DBMS_CLOUD.COPY_DATA supports the following for loading from JSON data in Object Store:

  • Create Credentials and Copy JSON Data into an Existing Table