Menu
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?
593
The main difference between Oracle 11g and 12c is that the Oracle 11g is an older version of Oracle RDBMS and has no pluggable databases while Oracle 12c is a newer version designed for the cloud and has pluggable databases.
You're absolutely right: Table names are 30 characters maximum same as column names.
Hi all, I think the maximum length of table and column name in oracle 11g is 30 characters.
The size of the database is the space the files physically consume on disk. You can find this with: select sum(bytes)/1024/1024 size_in_mb from dba_data_files; But not all this space is necessarily allocated.
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.
182
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.
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
