|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Internal Persistent LOBs, 11 of 43
"Use Case Model: Internal Persistent LOBs Operations", for all Internal Persistent LOB operations.
This procedure describes how to load data into an internal LOB.
See Usage Notes and Examples above.
LOBs can be quite large in size, it makes sense that SQL*Loader can load
LOB data from either the main datafile (that is, inline with the rest of the data) or from one or more secondary datafiles.
LOB data from the main datafile, the usual SQL*Loader formats can be used.
LOB data instances can be in predetermined size fields, delimited fields, or length-value pair fields.