Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 28 Jul 2006 @ 12:33:57 GMT


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


Subj:   Re: Oracle to Teradata Migration and Max Row Size
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 28, 2006 07:15 -->

Hi,

64KB is not 64000. If you use 65536 as your row size, Teradata doesn't support that. There is a maximum limit for the row size, which is a little less than 64K. I think I have to look into the manual for the exact size for a max sized row.

     database db1;

      *** New default database accepted.
      *** Total elapsed time was 1 second.

     +---------+---------+---------+---------+---------+---------+
     create table t1(c char(65535));

     create table t1(c char(65535));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t2(c char(65536));

     create table t2(c char(65536));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t3(c char(65534));

     create table t3(c char(65534));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t4(c char(65533));

     create table t4(c char(65533));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t5(c char(65532));

     create table t5(c char(65532));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t6(c char(65531));

     create table t6(c char(65531));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t7(c char(64768));

     create table t7(c char(64768));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t8(c char(64760));

     create table t8(c char(64760));
                                 $
      *** Failure 3798 A column or character expression is larger
                     than the max size.
                     Statement# 1, Info =30
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     create table t9(a int,  b int, c char(64000), d char(150));

      *** Table has been created.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+


     
  <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: 27 Dec 2016