Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Dec 2008 @ 15:36:01 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: How to migrate blob object from oracle to
 
From:   Rob Paller

Sridhar,

There are limitations with the native load utilities on Teradata for handling CLOBs. BTEQ can import them but are limited to roughly 64K. MultiLoad and FastLoad will not allow them. From the reading I have done recently on the archives at teradataforum.com your other options are CLI and JDBC programming. I am investigating if other tools would help work around the limitations of the native load utils.

There is an orange book available from Teradata @Your Service from 2003 on the subject. I am surprised there isn't anything more current given burgeoning trend for unstructured data analytics.

Hope this helps.


Regards,

Rob



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023