ERR-31233
The fixed record size exceeds the page size
Version
All versions
Explanation
Unable to create view.
iSQL> create table t1(c1 char(5000);Create success.iSQL> create table t2(c1 char(5000)) tablespace sys_tbs_disk_data;Create success. |
This error occurs if a fixed column that exceeds 32K for memory tables or 8K for disk tables is used. Disk tables use disk temporary tables for sorting/grouping operations. This error can occur if the length of a temporary record exceeds 8K.
Action
1. Set the table column to VARIABLE, not FIXED when creating for the first time.
2. If the error occurs when executing the SELECT statement using disk temporary tables, the memory temporary table should be used with the hint /*+ temp_tbs_memory */.
Reference
N/A
Copyright ⓒ 2000~2016 Altibase Corporation. All Rights Reserved.
These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.