Oracle8i Application Developer's Guide - Large Objects (LOBs)
Release 2 (8.1.6)

Part Number A76940-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Managing LOBs , 5 of 10


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

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

Other topics discussed are

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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index