Mutliple database objects have names that exceed Oracle's maximum

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.

Activity

Show:

Anthony Whyte February 22, 2011 at 9:29 AM

Trunk r88413 in 2.8.x, r88482. See PRFL-550.

Steve Swinsburg February 16, 2011 at 4:29 PM

docs/conversion only updated in trunk, needs merging. See

Steve Swinsburg February 16, 2011 at 12:37 PM

Thanks for the verification. Reopen if required.

Seth Theriault February 16, 2011 at 8:21 AM

Local testing shows the r88413 changes to 2.8 conversion script run without errors.

Hudson CI Server February 14, 2011 at 9:09 PM

Integrated in sakai trunk #446 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/446/)
update in docs/conversion too

Fixed

Details

Priority

Affects versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Environment

Oracle 9i
Created February 14, 2011 at 12:59 PM
Updated July 15, 2014 at 7:12 AM
Resolved February 14, 2011 at 4:33 PM