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
--------- -------- -----
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?