Loading InLine and Out-Of-Line Data into Internal LOBs Using SQL Loader

The following sections describe procedures for loading differently formatted inline and out-of-line data into internal LOBs:

• Loading InLine LOB Data
  • Loading Inline LOB Data in Predetermined Size Fields

  • Loading Inline LOB Data in Delimited Fields

  • Loading Inline LOB Data in Length-Value Pair Fields

• Loading Out-Of-Line LOB Data
  • Loading One LOB Per File

  • Loading Out-of-Line LOB Data in Predetermined Size Fields

  • Loading Out-of-Line LOB Data in Delimited Fields

  • Loading Out-of-Line LOB Data in Length-Value Pair Fields

Other topics discussed are

• SQL Loader LOB Loading Tips

SQL Loader Performance: Loading Into Internal LOBs

See Table 4-1, "SQL Loader Performance: Loading Data Into Internal LOBs" for the relative performance when using the above methods of loading data into internal LOBs.

Table 4-1 SQL Loader Performance: Loading Data Into Internal LOBs

Loading Method For In-Line or Out-Of-Line Data	Relative Performance
In Predetermined Size Fields	Highest
In Delimited Fields	Slower
In Length Value-Pair Fields	High
One LOB Per File	High

See Also: Chapter 9, "LOBS: Best Practices"