December 2002
Intermediate to advanced
928 pages
85h 29m
English
The special syntax for LOB data that you are loading from an external file is:
column_nameLOBFILE (fieldname| CONSTANTfilename[CHARACTERSETcharsetname])
where fieldname is the name of a field in the INFILE that has the filename for the LOB data, which is usually a filler field. The filename is the filename of the file that contains the LOB data. If you load LOBs from an external file, SQL*Loader does not have to allocate memory for their temporary storage.