[
https://issues.apache.org/jira/browse/SENTRY-1934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Na Li updated SENTRY-1934:
--------------------------
Status: Patch Available (was: Open)
> SQL 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
> Attachments: SENTRY-1934.001.patch
>
>
> 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)
