Version
All versions
Explanation
Unable to create view.
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