Na Li created SENTRY-1934:
-----------------------------

             Summary: Index name is too long for Oracle 11.2
                 Key: SENTRY-1934
                 URL: https://issues.apache.org/jira/browse/SENTRY-1934
             Project: Sentry
          Issue Type: Bug
          Components: Sentry
    Affects Versions: 2.0.0
            Reporter: Na Li
            Assignee: Na Li


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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to