batch loading clobs
From: Rachel Pevtzow <rsp_at_soton.ac.uk>
Date: Fri, 23 Apr 2004 13:55:32 +0100
Message-ID: <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.
Date: Fri, 23 Apr 2004 13:55:32 +0100
Message-ID: <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!
Received on Fri Apr 23 2004 - 14:55:32 CEST