Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 17 Dec 2008 @ 16:29:22 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: How to migrate blob object from oracle to
From:   Dempsey, Mike

I don't know how big your LOBs are but the max size of VARCHAR and VARBYTE in Teradata is larger than for most other databases. (Some are as small as 4K)

If your LOBs are smaller than 64K you might therefore want to consider the option of using those data types rather than LOBs. (This decision has its own pros and cons)

SQL Assistant is capable of importing larger LOBs, but this is not a bulk load tool (ie. It is slow) and it requires that each LOB be a file on the pc/server that is running the app.

Mike Dempsey
Teradata Client Tools

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