Loading Initial Data into a BLOB, CLOB, or NCLOB

Figure 10-15 Use Case Diagram: Loading Initial Data into a BLOB, CLOB, or NCLOB

Text description of the illustration adl10p18.gif

See: "Use Case Model: Internal Persistent LOBs Operations", for all Internal Persistent LOB operations.

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: Oracle9i 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. LOB data instances can be in predetermined size fields, delimited fields, or length-value pair fields.