Load Data into an Internal LOB (BLOB, CLOB, NCLOB)

Figure 9-15 Use Case Diagram: Load Initial Data into an Internal LOB

See: "Use Case Model: Internal Persistent LOBs Basic Operations", for all basic operations of Internal Persistent LOBs.

Purpose

This procedure describes how to load data into an internal LOB.

Usage Notes and Examples

For detailed information and tips on using SQL Loader for loading data into an internal LOB see Chapter 4, "Managing LOBs", "Using SQL Loader to Load 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

    See Also: Oracle8i Utilities-- "SQL Loader"

Syntax

See Usage Notes and Examples above.

Scenario

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

To load LOB data from the main datafile, the usual SQL*Loader formats can be used. The LOB data instances can be in predetermined size fields, delimited fields, or length-value pair fields.