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?
What is the maximum size of table/column/index names in Oracle 12c?
Asked
Active
Viewed 2.6k times
12
-
4We all would love to use identifiers >30 chars, but why do you *need* them? – Jeffrey Kemp Aug 16 '13 at 05:51
-
3I wonder how you can cope without them. Having to compress the name of a table to fit 30 characters can lead to all sorts of issues with readability. – JamesF Aug 26 '14 at 08:00
2 Answers
26
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.
The 30 bytes object names restriction has been lifted in second release of Oracle Database 12c ( 12cR2) and if the value of the COMPATIBLE initialization parameter is set to 12.2 or higher then object names' length can be up to 128 bytes.
Marc
- 3,683
- 8
- 34
- 48
Nick Krasnov
- 26,886
- 6
- 61
- 78
3
I know of no way to change the maximum size of fields to more than 30 characters in 11g.
I've seen nothing to suggest this is changing in 12c.
cagcowboy
- 30,012
- 11
- 69
- 93
-
12
-
1
-
6Access may be bad, but at least it's user friendly. Oracle is neither good nor usable. – chubbsondubs Feb 25 '15 at 00:48
-
6I would argue that 'it's user friendly' will greatly depend on who the *user is*. Access is the most painful DB to use for me (software developer) but the best DB on the planet for my wife (insurance analyst). – Vladaimir Cetkovic May 16 '16 at 04:36