It's said External Table works on the same mechanism as SQL*Loader.
Here is an example to load LOB data. You can refer to Oracle8i/9i
Utilities doc. for details.
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_at_us.oracle.com ... <endlob>
2 |Speed Racer, .......
Notes:
1. <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.
2. 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 hexadecimal notation,
X'7C0A').
Received on Tue Nov 23 2004 - 21:34:40 CST
