Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 14:50:43 GMT


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


Subj:   Extract and Load of CLOB : From Oracle to Teradata.
 
From:   Kallarakkal, Baburaj

We are in process of moving an application from Oracle to Teradata, but ran into issues on one of the tables which has a CLOB column in it.

To do a trial test run can anyone please send a sample bteq script, created a Test table like below. Wanted to try and do a test run to load an XML/Text file into this and see if it works as the first step.

     CREATE SET TABLE RBClobTestA ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          DATABLOCKSIZE = 130560 BYTES, FREESPACE = 20 PERCENT, CHECKSUM = DEFAULT
          (
           CLOBCOL CLOB(2097088000) CHARACTER SET LATIN,
           ID INTEGER)
     PRIMARY INDEX ( ID );

With your prior experiences does anyone have any tips/suggestions/thoughts while we do this?. Thanks in advance.


Regards,

Raj



     
  <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