Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
batch loading clobs
0 views
Skip to first unread message
Rachel Pevtzow
Apr 23, 2004, 8:40:29 AM4/23/04
to
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.
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!
0 new messages