Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 May 2005 @ 14:09:33 GMT


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


Subj:   Failure 5708 Table header size exceeds limit
 
From:   Shaju Kodian

Hi,

While creating partitioned table following error is thrown

     '*** Failure 5708 Table header size exceeds limit.'

Is there any limit on number of partitions getting created ? Can anyone provide the workaround to create more than 50 partitions.


Thanks,

Sh.


     CREATE MULTISET TABLE policies,

     NO FALLBACK, NO BEFORE JOURNAL,NO AFTER JOURNAL

     (
       Nopolice            VARCHAR( 12 )        NULL ,
       Nosiegex            VARCHAR( 4 )         NULL ,
       Cogarant            VARCHAR( 2 )         NULL ,
       Cgarxxxx            VARCHAR( 4 )         NULL ,
       Csign               VARCHAR( 2 )         NULL ,
       Cmvt                VARCHAR( 2 )         NULL ,
       Ctypquit            CHARACTER( 1 )       NULL ,
       Cbrcat              VARCHAR( 8 )         NULL ,
       Categorie           VARCHAR( 3 )         NULL ,
       Divgar              VARCHAR( 1 )         NULL ,
       Cdiv                VARCHAR( 3 )         NULL ,
       Ddcouv              VARCHAR( 6 )         NULL ,
       Jdcouv              VARCHAR( 2 )         NULL ,
       Dfcouv              VARCHAR( 6 )         NULL ,
       Jfcouv              VARCHAR( 2 )         NULL ,
       Mprnet              DECIMAL ( 18, 3 )    NULL ,
       Ncptprad            VARCHAR( 14 )        NULL ,
       Mcencais            DECIMAL ( 18, 3 )    NULL ,
       Cptencais           VARCHAR( 14 )        NULL ,
       Mcacquis            DECIMAL ( 18, 3 )    NULL ,
       Cptacquis           VARCHAR( 14 )        NULL ,
       Mcgestxx            DECIMAL ( 18, 3 )    NULL ,
       Cptgestion          VARCHAR( 14 )        NULL ,
       Ccoass              CHARACTER( 1 )       NULL ,
       Cbr                 VARCHAR( 2 )         NULL ,
       Dcpbl               VARCHAR( 6 )         NULL ,
       Jcpbl               VARCHAR( 2 )         NULL ,
       Cdevise             VARCHAR( 3 )         NULL ,
       Br                  VARCHAR( 2 )         NULL ,
       Cgartech            VARCHAR( 3 )         NULL ,
       Ciecpbl             VARCHAR( 2 )         NULL ,
       Canal               VARCHAR( 4 )         NULL ,
       Entrequit           VARCHAR( 2 )         NULL ,
       Crgn                VARCHAR( 2 )         NULL ,
       Nprodquit           VARCHAR( 8 )         NULL ,
       Fraisfrac           DECIMAL ( 18, 3 )    NULL ,
       Fraispol            DECIMAL ( 18, 3 )    NULL ,
       Cgarent             VARCHAR( 3 )         NULL ,
       Produitent          VARCHAR( 6 )         NULL ,
       Typaff              VARCHAR( 2 )         NULL ,
       Sigprim             CHARACTER( 1 )       NULL ,
       Crglang             CHARACTER( 1 )       NULL ,
       Nprodent            VARCHAR( 8 )         NULL ,
       Account_X           VARCHAR( 12 )        NULL ,
       Sl                  VARCHAR( 8 )         NULL ,
       Stat_X              VARCHAR( 8 )         NULL ,
       Entreqent           VARCHAR( 2 )         NULL ,
       Typprod             CHARACTER( 1 )       NULL ,
       Cpcent              CHARACTER( 1 )       NULL ,
       Typexer             CHARACTER( 1 )       NULL ,
       Nquit               VARCHAR( 11 )        NULL ,
       Cme                 CHARACTER( 1 )       NULL ,
       Objet               VARCHAR( 3 )         NULL ,
       Tlegale             DECIMAL ( 18, 3 )    NULL ,
       Fhand               DECIMAL ( 18, 3 )    NULL ,
       Fhandac             DECIMAL ( 18, 3 )    NULL ,
       Inami               DECIMAL ( 18, 3 )    NULL ,
       Inamiac             DECIMAL ( 18, 3 )    NULL ,
       Crouge              DECIMAL ( 18, 3 )    NULL ,
       Fat                 DECIMAL ( 18, 3 )    NULL ,
       Fsecur              DECIMAL ( 18, 3 )    NULL ,
       T12t                DECIMAL ( 18, 3 )    NULL ,
       Fdivers             DECIMAL ( 18, 3 )    NULL ,
       Gest                VARCHAR( 3 )         NULL ,
       Nflotgc             VARCHAR( 12 )        NULL ,
       Libflotte           VARCHAR( 30 )        NULL ,
       Grcmpte             VARCHAR( 4 )         NULL ,
       Polentcon           VARCHAR( 12 )        NULL ,
       Preneurn            VARCHAR( 35 )        NULL ,
       Preneurp            VARCHAR( 16 )        NULL ,
       Preneurcp           VARCHAR( 4 )         NULL ,
       Formule             VARCHAR( 8 )         NULL ,
       Cnace               VARCHAR( 8 )         NULL ,
       Decheance           VARCHAR( 8 )         NULL ,
       Deffet              VARCHAR( 8 )         NULL ,
       Dfin                VARCHAR( 8 )         NULL ,
       Cmotif              VARCHAR( 2 )         NULL ,
       Cfrac               VARCHAR( 2 )         NULL ,
       Typquitptf          VARCHAR( 1 )         NULL ,
       Brcanevas           VARCHAR( 4 )         NULL ,
       Corg                VARCHAR( 1 )         NULL ,
       Area                VARCHAR( 12 )        NULL ,
       Secteur             VARCHAR( 1 )         NULL ,
       Cgpreas             VARCHAR( 2 )         NULL ,
       Ciebt               VARCHAR( 2 )         NULL ,
       Pgaccats            VARCHAR( 4 )         NULL ,
       Uab_Cd              VARCHAR( 1 )         NULL

     )
     PRIMARY INDEX
     (
       Nopolice

     )
     PARTITION BY CASE_N

     (
       Dcpbl < 200002
       , Dcpbl < 200003
       , Dcpbl < 200004
       , Dcpbl < 200005
       , Dcpbl < 200006
       , Dcpbl < 200007
       , Dcpbl < 200008
       , Dcpbl < 200009
       , Dcpbl < 200010
       , Dcpbl < 200011
       , Dcpbl < 200012
       , Dcpbl < 200101
       , Dcpbl < 200102
       , Dcpbl < 200103
       , Dcpbl < 200104
       , Dcpbl < 200105
       , Dcpbl < 200106
       , Dcpbl < 200107
       , Dcpbl < 200108
       , Dcpbl < 200109
       , Dcpbl < 200110
       , Dcpbl < 200111
       , Dcpbl < 200112
       , Dcpbl < 200201
       , Dcpbl < 200202
       , Dcpbl < 200203
       , Dcpbl < 200204
       , Dcpbl < 200205
       , Dcpbl < 200206
       , Dcpbl < 200207
       , Dcpbl < 200208
       , Dcpbl < 200209
       , Dcpbl < 200210
       , Dcpbl < 200211
       , Dcpbl < 200212
       , Dcpbl < 200301
       , Dcpbl < 200302
       , Dcpbl < 200303
       , Dcpbl < 200304
       , Dcpbl < 200305
       , Dcpbl < 200306
       , Dcpbl < 200307
       , Dcpbl < 200308
       , Dcpbl < 200309
       , Dcpbl < 200310
       , Dcpbl < 200311
       , Dcpbl < 200312
       , Dcpbl < 200401
       , Dcpbl < 200402
       , Dcpbl < 200403
       , Dcpbl < 200404
       , Dcpbl < 200405
       , Dcpbl < 200406
       , Dcpbl < 200407
       , Dcpbl < 200408
       , Dcpbl < 200409
       , Dcpbl < 200410
       , Dcpbl < 200411
       , Dcpbl < 200412
       , Dcpbl < 200501
       , Dcpbl < 200502
     );

 *** Failure 5708 Table header size exceeds limit.
                Statement# 1, Info =0
      *** 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