Skip to Content
0
Former Member
May 16, 2013 at 10:16 AM

exceeded row size of 88 bytes

46 Views

the following table exists:

Column_name Type Length Prec Scale Nulls Default_name Rule_name Access_Rule_name Computed_Column_object Identity

------------------ ------- ------ ---- ----- ----- ------------ --------- ---------------- ---------------------- ----------

event_transferno_i int 4 NULL NULL 0 def_min1 NULL NULL NULL 0 dimension varchar 2 NULL NULL 0 def_blank NULL NULL NULL 0 due_at int 4 NULL NULL 1 NULL NULL NULL NULL 0 mutation int 4 NULL NULL 1 def_zero NULL NULL NULL 0 mutator varchar 8 NULL NULL 1 def_blank NULL NULL NULL 0 status int 4 NULL NULL 1 def_zero NULL NULL NULL 0 mutation_time int 4 NULL NULL 1 NULL NULL NULL NULL 0 created_by varchar 8 NULL NULL 1 NULL NULL NULL NULL 0 created_date int 4 NULL NULL 1 NULL NULL NULL NULL 0

If i run this update:

UPDATE mytable SET counterno_i = 62282 WHERE wo_transfer_dimension.event_transferno_i IN (32950, 32956) AND wo_transfer_dimension.dimension = 'D'

this error occurs:

Attempt to update or insert row failed because resultant row of size 6951 bytes is larger than the maximum size (88 bytes) allowed for this table.

How can the maximum row size be 88 bytes on a 2k page size server ?