Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 23 Oct 2002 @ 12:50:25 GMT

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

Subj:   Re: Does Teradata Support CLOB? Urgent !
From:   Geoffrey Rommel

  In another instance of loading a table i encountered this error(below). How do i increase the maximum row length/size? Can it be done or is it fixed to 64K.....  

  **** 09:32:28 Current CLI or RDBMS allows maximum row size: 64K
**** 09:32:30 RDBMS error 3933: The Maximum Possible Row Length in the Table is too Large.

The maximum row length is limited by the maximum block size. In V2R4.1, you have the option of setting this to 128K via the global parameter PermDBSize. Caution! This has system-wide implications and is not for the faint of heart. Seek professional help from NCR. For some basic information, see Database Administration, chapter 3, section "Monitoring Disk Space".

  <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