Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,329 of 2,288    |
|    Rachel Pevtzow to All    |
|    batch loading clobs    |
|    23 Apr 04 13:40:29    |
      XPost: comp.database.oracle, comp.database.oracle.misc, comp.dat       base.oracle.server       XPost: comp.database.oracle.tools       From: rsp@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!              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca