Re: batch loading clobs

#1

"Rachel Pevtzow" <rsp (AT) soton (DOT) ac.uk> wrote

Quote:

i currently have a few (non-oracle) databases containing personal papers
of
wellington, mountbatten, etc. i'm thinking about moving it into oracle,
but
i'm worried about how to get the data in. the limit on character fields
in
the current database system is 65000 characters, and we've run into that a
number of times. i've used sqloader to get data into oracle databases in
the past, but i've never worked with clobs before.

i can output the data into csv (one/database), but is there any way to
batch
load them into oracle? as far as i can make out, it doesn't sound
possible
using sqldr. or am i mistaken?

any advice would be appreciated!

Rachel,

You may wish to review "Load LOBs" in Chapter 9: "Data Loading" of "Expert
One-on-One Oracle" by Thomas Kyte (A-Press:2003), or go to "Mass Loading
BLOBs into a database" at
http://asktom.oracle.com/pls/ask/f?p...D:392618837633
for further information.

Douglas Hawthorne

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: batch loading clobs

comp.database.oracle comp.database.oracle

Re: batch loading clobs - 04-23-2004 , 08:04 AM