Oracle JDEdwards EnterpriseOne Table Trivia

Prior to version 8.9, the maximum number of columns in a table was 254. However, since then, the table property limits have been stored in the F9300 (Database Property Values) table.

The F9300 contains values for the following properties:

• Maximum Column Name Length
• Maximum Index Name Length
• Maximum Number Of Blobs In Table
• Maximum Number Of Columns In Index
• Maximum Number Of Indexes In Table
• Maximum Table Name Length
• Maximum Total Index Length
• Maximum Total Row Length
• Minimum Column Name Length
• Minimum Index Name Length
• Minimum Number Of Blobs In Table
• Minimum Number Of Columns In Index
• Minimum Number Of Columns In Table
• Minimum Number Of Indexes In Table
• Minimum Table Name Length
• Minimum Total Index Length
• Minimum Total Row Length

Changing the defined values in the F9300 – Database Property Values table is not recommended or supported.