 |
 |
Archives of the TeradataForum
Message Posted: Thu, 05 May 2005 @ 14:09:33 GMT
| 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.
| |
