This content has been marked as final. Show 3 replies
The arguments of the SDO_RDF_TRIPLE_S constructor do not match the attribute fields. See "Loading Column Objects with User-Defined Constructors" in the Oracle® Database Utilities 10g Release 2 (10.2) (Part Number B14215-01) document to see how such a constructor can be invoked during the load process.
Here is an example of a control file:
INFILE 'mt_data.txt' BADFILE 'mt_data.bad'
INTO TABLE mt_1
subj boundfiller char terminated by whitespace,
pred boundfiller char terminated by whitespace,
obj boundfiller char terminated by '.',
triple expression "sdo_rdf_triple_s('test_model',:SUBJ, :PRED, :OBJ)"
Please note that the current documented way of loading is using the java batch loader which is on the semantic technologies OTN page. Some other users have used SQL*Loader successfully, though we have not yet internally tested this for large data sets. We plan to do that in the future and I will post recommendations accordingly.
Oracle Semantic Technologies Development Group
Thank you Melli for the sample .ctl file. I was able to use sqlldr to load a triple store using a conventional load. Direct loading is not supported, correct? This is the error I received when using direct=true
SQL*Loader-951: Error calling once/load initialization
ORA-26052: Unsupported type 121 for SQL expression on column TRIPLE.
That is correct, direct load is not supported currently.