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').
----------------------------------------------------------------------
|
|
|