Hi, I create a table with ID and data and able to insert json data one by one. I would like to know how to use sqlldr to load a big file?
CREATE TABLE adsb_json
(ID RAW(16) NOT NULL,
data varchar2(4000) NOT NULL,
);
ALTER TABLE adsb_json
ADD CONSTRAINT json
CHECK (data IS JSON);
insert into adsb_json (id, data) values (sys_guid(),'{"Id":10491068,"Rcvr":1,"HasSig":false,"Icao":"A014BC","Bad":false,"Reg":"N104N","FSeen":"\/Date(1502465754324)\/","TSecs":53,"CMsgs":29,"Alt":2450,"GAlt":2409,"InHg":29.8789368,"AltT":0,"Call":"N104N","Lat":33.689438,"Long":-112.037315,"PosTime":1502465805981,"Mlat":false,"Tisb":false,"Spd":122.0,"Trak":88.1,"TrkH":false,"Type":"RV10","Mdl":"2007 RAINEY NORMAN W RV-10","Man":"Vans","CNum":"40348","Op":"RAINEY NORMAN W - INDEPENDENCE, OR","Sqk":"","Vsi":640,"VsiT":0,"Dst":28.57,"Brng":354.6,"WTC":1,"Species":1,"Engines":"1","EngType":1,"EngMount":0,"Mil":false,"Cou":"United States","HasPic":false,"Interested":false,"FlightsCount":0,"Gnd":false,"SpdTyp":0,"CallSus":false,"Trt":2,"Year":"2007"}');
How can I load this?
[{"Id":10491068,"Rcvr":1,"HasSig":false,"Icao":"A014BC","Bad":false,"Reg":"N104N","FSeen":"\/Date(1502465754324)\/","TSecs":53,"CMsgs":29,"Alt":2450,"GAlt":2409,"InHg":29.8789368,"AltT":0,"Call":"N104N","Lat":33.689438,"Long":-112.037315,"PosTime":1502465805981,"Mlat":false,"Tisb":false,"Spd":122.0,"Trak":88.1,"TrkH":false,"Type":"RV10","Mdl":"2007 RAINEY NORMAN W RV-10","Man":"Vans","CNum":"40348","Op":"RAINEY NORMAN W - INDEPENDENCE, OR","Sqk":"","Vsi":640,"VsiT":0,"Dst":28.57,"Brng":354.6,"WTC":1,"Species":1,"Engines":"1","EngType":1,"EngMount":0,"Mil":false,"Cou":"United States","HasPic":false,"Interested":false,"FlightsCount":0,"Gnd":false,"SpdTyp":0,"CallSus":false,"Trt":2,"Year":"2007"},{"Id":10974892,"Rcvr":1,"HasSig":true,"Sig":14,"Icao":"A776AC","Bad":false,"Reg":"N580HW","FSeen":"\/Date(1502465739480)\/","TSecs":68,"CMsgs":29,"Alt":2900,"GAlt":2841,"InHg":29.8612213,"AltT":0,"Call":"N580HW","Lat":33.459421,"Long":-111.954663,"PosTime":1502465800512,"Mlat":false,"Tisb":false,"Spd":174.9,"Trak":63.1,"TrkH":false,"Type":"CVLT","Mdl":"1952 CONVAIR 340-31","Man":"Convair","CNum":"CVAC2","Op":"HONEYWELL INTERNATIONAL INC - REDMOND, WA","Sqk":"0762","Help":false,"Vsi":1792,"VsiT":0,"Dst":5.73,"Brng":60.0,"WTC":2,"Species":1,"Engines":"2","EngType":2,"EngMount":0,"Mil":false,"Cou":"United States","HasPic":false,"Interested":false,"FlightsCount":0,"Gnd":false,"SpdTyp":0,"CallSus":false,"Trt":2,"Year":"1952"}]