Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008

    Unanswered: Attempt to update or insert row failed

    I get following error when I try to update the table.
    "Attempt to update or insert row failed because resultant row of size 9500 bytes is larger than the maximum size (1961 bytes) allowed for this table.

    Here is the definition of the table(RAC):

    ColumnName DataType Size
    --------- -------- -----

    VALID int
    PARTID int
    STRVAL varchar 11000

    Here is the query I have used to update the above table:

    UPDATE RAC SET STRVAL = 'String is of length 10,000 characters......' where VALID = 20
    How to resolve this error?
    Could you please let me know is it possible to change the page size of table?


  2. #2
    Join Date
    Sep 2003
    varchars/chars can only go upto the max page size which is 2k in default.

    You should instead have the column defined as text.

    1> create table (a int, b text)

    1> insert into a
    2> select 1, replicate('Repeat this 2000 times',2000)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts