Re: batch loading clobs

Rachel Pevtzow wrote:

> 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!
>
>

This is clearly a c.d.o.server (sqlldr) question, so it was anly answered here.

No problem; you can up the size - I've done sqlldr sessions with 256kB worth of (character) data.

-- 

Regards,
Frank van Bortel