Hello,
I use Oracle Express V21.3 and have two tables with the same structure
The first one has two columns; id and a CLOB data type column for JSON data
The second one has two columns: id and a JSON data type column for JSON data.
I intend to load thousands of JSON documents in both tables and use the SQL*Loader for that.
All JSON documents, for loading, are similar and look as follows:
{ "city":"CHICOPEE", "loc" : [ -72.576142, 42.176443 ], "pop" : 31495, "state" : "MA", "_id" : "01020"}
The loading process for the first table with 10 such documents, as a test, works well.
The loading process for the second table with one such document displays the ORA:40441 error. (If I reduce the document to one object, it works well for the second table, too.)
How do I have to write such JSON documents (see the example above) to get it loaded into the second table?
Thanks in advance.
Dusan Petković