Mutliple database objects have names that exceed Oracle's maximum
GENERAL
TESTING
GENERAL
TESTING
Description
In the Sakai 2.7 -> 2.8 conversion scripts, the following errors were generated:
create index PROFILE_COMPANY_PROFILES_USER_UUID_I on PROFILE_COMPANY_PROFILES_T (USER_UUID) * ERROR at line 1: ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_UUID_I on PROFILE_MESSAGE_PARTICIPANTS_T (PARTICIPANT_UUID) * ERROR at line 1: ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_MESSAGE_ID_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_ID) * ERROR at line 1: ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_DELETED_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_DELETED) * ERROR at line 1: ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_READ_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_READ) * ERROR at line 1: ORA-00972: identifier is too long
create index PROFILE_GALLERY_IMAGES_USER_UUID_I on PROFILE_GALLERY_IMAGES_T (USER_UUID) * ERROR at line 1: ORA-00972: identifier is too long
In Oracle, an object's name is generally limited to 30 characters.
In the Sakai 2.7 -> 2.8 conversion scripts, the following errors were generated:
create index PROFILE_COMPANY_PROFILES_USER_UUID_I on PROFILE_COMPANY_PROFILES_T (USER_UUID)
*
ERROR at line 1:
ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_UUID_I on PROFILE_MESSAGE_PARTICIPANTS_T (PARTICIPANT_UUID)
*
ERROR at line 1:
ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_MESSAGE_ID_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_ID)
*
ERROR at line 1:
ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_DELETED_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_DELETED)
*
ERROR at line 1:
ORA-00972: identifier is too long
create index PROFILE_MESSAGE_PARTICIPANT_READ_I on PROFILE_MESSAGE_PARTICIPANTS_T (MESSAGE_READ)
*
ERROR at line 1:
ORA-00972: identifier is too long
create index PROFILE_GALLERY_IMAGES_USER_UUID_I on PROFILE_GALLERY_IMAGES_T (USER_UUID)
*
ERROR at line 1:
ORA-00972: identifier is too long
In Oracle, an object's name is generally limited to 30 characters.