Re: batch loading clobs

"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....

http://www.csee.umbc.edu/help/oracle8/inter.815/a67843/aload.htm#3627

i like first method, because it's pure plsql and you don't need control files...

jiri Received on Mon Apr 26 2004 - 00:27:41 CDT