Skip to content

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#

  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