Home » RDBMS Server » Server Utilities » Re: How to use SQL*Loader to load binary data -- Help!!!
Re: How to use SQL*Loader to load binary data -- Help!!! [message #68943] Mon, 01 October 2001 16:24
bubu
Messages: 1
Registered: October 2001
Junior Member
LOB Data in Delimited Fields

This format handles LOBs of different sizes within the same column (datafile field) without problem. Note, however, that this added flexibility can impact performance because SQL*Loader must scan through the data, looking for the delimiter string. See Secondary Data Files (SDFs) and LOBFILES.

Example 5-11 Loading LOB Data in Delimited Fields
Control File
LOAD DATA
INFILE 'sample.dat' "str '|'"
INTO TABLE person_table
FIELDS TERMINATED BY ','
(name CHAR(25),
1 "RESUME" CHAR(507) ENCLOSED BY '<startlob>' AND '<endlob>')

Data file (sample.dat)

Johny Quest,<startlob> Johny Quest
500 Oracle Parkway
jquest@us.oracle.com ... <endlob>
2 |Speed Racer, .......

Notes:

<startlob> and <endlob> are the enclosure strings. Note that the maximum length for a LOB that can be read using the CHAR(507) is 507 bytes.

If the record separator '|' had been placed right after <endlob> and followed with the newline character, the newline would have been interpreted as part of the next record. An alternative would be to make the newline part of the record separator (for example, '|n' or, in hex, X'7C0A').

----------------------------------------------------------------------
Previous Topic: Re: Using FILLER field in WHEN clause in SQLldr
Next Topic: Re: Oracle8 and windows 2000
Goto Forum:
  


Current Time: Thu Mar 28 17:20:29 CDT 2024