A LOB is a large object type. This release of SQL*Loader supports loading of four LOB data types:
BLOB
: a LOB containing unstructured binary data
CLOB
: a LOB containing character data
NCLOB
: a LOB containing characters in a database national character set
BFILE
: a BLOB
stored outside of the database tablespaces in a server-side operating system file
LOBs can be column data types, and except for NCLOB
, they can be an object's attribute data types. LOBs can have an actual value, they can be null
, or they can be "empty."
"Loading LOBs" for details on using SQL*Loader control file data definition language to load these LOB types