* Schema Changes: Regarding Oracle systems upgrading from an older version. 1) Change the LONG columns to CLOBs: ALTER TABLE FBT_BUG_STRUCT MODIFY ( FBT_NOTIFYLIST CLOB ); ALTER TABLE FBT_BUG_STRUCT_ENTRY MODIFY ( FBT_DESCRIPTION CLOB ); ALTER TABLE FBT_BUG_USER_FIELD MODIFY ( FBT_STRING_VALUE CLOB ); ALTER TABLE FBT_BUG_USER_FIELD_ENTRY MODIFY ( FBT_STRING_VALUE CLOB ); ALTER TABLE FBT_CFG_DEF MODIFY ( FBT_CFG_INFO CLOB ); ALTER TABLE FBT_CHART_DEF MODIFY ( FBT_CHART_INFO CLOB ); ALTER TABLE FBT_COLORCODE_DEF MODIFY ( FBT_COLORCODE_INFO CLOB ); ALTER TABLE FBT_DASHBOARD MODIFY ( FBT_DASHBOARD_INFO CLOB ); ALTER TABLE FBT_DASHBOARD_COMPONENT MODIFY ( FBT_COMPONENT_INFO CLOB ); ALTER TABLE FBT_EVENT_DEF MODIFY ( FBT_EVENT_INFO CLOB ); ALTER TABLE FBT_FLD_DEF MODIFY ( FBT_FLD_INFO CLOB ); ALTER TABLE FBT_FLT_DEF MODIFY ( FBT_FLT_INFO CLOB ); ALTER TABLE FBT_GROUP_DEF MODIFY ( FBT_GROUP_INFO CLOB ); ALTER TABLE FBT_HS_DEF MODIFY ( FBT_HS_INFO CLOB ); ALTER TABLE FBT_MAILRULE_DEF MODIFY ( FBT_MAILRULE_INFO CLOB ); ALTER TABLE FBT_PROJECT_DEF MODIFY ( FBT_PROJECT_INFO CLOB ); ALTER TABLE FBT_REPORT_DEF MODIFY ( FBT_REPORT_INFO CLOB ); ALTER TABLE FBT_RET_DEF MODIFY ( FBT_RET_INFO CLOB ); ALTER TABLE FBT_USER_DEF MODIFY ( FBT_USER_INFO CLOB ); ALTER TABLE FBT_WF_DEF MODIFY ( FBT_WF_INFO CLOB ); 2) Rebuild the indexes for each of the above tables. For example: SELECT index_name FROM user_indexes WHERE table_name=FBT_BUG_STRUCT; This will show an index name similar to SYS_C0011514. Rebuild the index: ALTER INDEX SYS_C0011514 REBUILD Repeat the "select" and "alter" commands for the indexes of each table listed in step #1.