[SENTRY-1934] SQL Index name is too long for Oracle 11.2

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: Sentry
• Assignee: Na Li
• Reporter: Na Li
• Created: 08/Sep/17 21:40
• Updated: 11/Sep/17 14:31
• Resolved: 11/Sep/17 14:31

Description

Prior to Oracle version 12.2, identifiers are not allowed to exceed 30 characters in length
Names must be from 1 to 30 bytes long with these exceptions:
Names of databases are limited to 8 bytes.
Names of database links can be as long as 128 bytes.

The following index name is 32 bytes, and cause exception "ORA-00972: identifier is too long" on oracle DB 11.2.

CREATE INDEX "SENTRY_HMS_NOTIFICATION_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID");

Need to change the index name to be smaller

Issue Links

• links to: Review Link for this case