Re: batch loading clobs
Date: 25 Apr 2004 22:27:41 -0700
"Rachel Pevtzow" <rsp_at_soton.ac.uk> wrote in message news:<c6b3nd$5pf$1_at_aspen.sucs.soton.ac.uk>...
> 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!
You can create stored procedure and kick in from SQLPlus.
check this sample http://www.oracle-base.com/articles/8i/ImportClob.php
or you can use sql*loader....
i like first method, because it's pure plsql and you don't need control files...
jiri Received on Mon Apr 26 2004 - 07:27:41 CEST