Re: Row size too large (> 8126).
Even if you increase the page size to 64KB, you can't put more than 16KB in one row. You must change the page size for _all_ tables in the server. This is not a pretty picture; let's try to solve your problem another way.
If you need 400 "fields", will you be really using more than a few of them in SQL? If not, then encode it as JSON and have one large column (TEXT or MEDIUMTEXT) that contains the JSON. (And have a few other columns for filtering/sorting/etc.)
Your application can do the encode/decode. What language are you using?
Subject
Written By
Posted
Re: Row size too large (> 8126).
May 23, 2016 04:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.