home bbs files messages ]

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,330 of 2,288   
   Rachel Pevtzow to All   
   batch loading clobs   
   23 Apr 04 13:55:32   
   
   XPost: comp.databases.oracle.misc, comp.databases.oracle.server,   
   comp.databases.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