Supported LOB Data Types

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."

See Also:

"Loading LOBs" for details on using SQL*Loader control file data definition language to load these LOB types