在Oracle 11g或12c中更改表/列/索引名称的大小 [英] Change table/column/index names size in oracle 11g or 12c
问题描述
我使用的是oracle 11g,并且需要名称,该大小必须大于30个字符,我知道11g中的最大大小为30个字符.
I use oracle 11g and need name that size is greater than 30 characters, I know the maximum size in 11g is 30 characters.
我可以更改此最大大小吗?
Can I change the this maximum size?
Oracle 12c中表/列/索引名称的最大大小是多少?
What is the maximum size of table/column/index names in Oracle 12c?
推荐答案
12cR1 限制为30个字节(在单字节字符集中,它将等于30个字符).可以更改吗?不,您不能进行任何更改以允许Oracle使用大于30个字节的对象名称.
Database object names in 11g as well as in 12cR1 are limited to 30 bytes (in a single-byte character set it will be equivalent to 30 characters). Can it be changed? No, you cannot make any changes to allow Oracle to use object names that are greater than 30 bytes.
30 bytes object names restriction has been lifted in second release of Oracle Database 12c ( 12cR2) and if value of COMPATIBLE initialization parameter is set to 12.2 or higher then object names' length can be up to 128 bytes.
这篇关于在Oracle 11g或12c中更改表/列/索引名称的大小的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!