|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Managing LOBs , 4 of 12
You can use SQL*Loader to bulk load LOBs. See "Loading LOBs" in Oracle9i Utilities for details on using SQL*Loader control file data definition language (DDL) to load LOB types.
Data loaded into LOBs can be lengthy and it is likely that you will want to have the data out- of-line from the rest of the data. LOBFILES provide a method to separate lengthy data.
LOBFILES are simple datafiles that facilitate LOB loading. LOBFILEs are distinguished from primary datafiles in that in LOBFILEs there is no concept of a record. In LOBFILEs the data is of any of the following types: