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.
Cause#
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#
-
Set the table column to VARIABLE, not FIXED when creating for the first time.
-
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