What is the maximum length of a table name in Oracle

Question

What are the maximum length of a table name and column name in Oracle

User · Answer

In Oracle 12 1 and below  30 char  bytes  really  as has been stated   But do not trust me  try this for yourself  SQL gt  create table I23456789012345678901234567890  my id number    Table created     SQL gt  create table I234567890123456789012345678901 my id number     ERROR at line 1   ORA-00972  identifier is too long  Updated  as stated above  in Oracle 12 2 and later  the maximum object name length is now 128 bytes

User · Answer

I m working on Oracle 12c 12 1  However  doesn t seem like it allows more than 30 characters for column table names   Read through an oracle page which mentions 30 bytes  https   docs oracle com database 121 SQLRF sql elements008 htm SQLRF00223  In 12c although the all tab columns do say VARCHAR2 128  for Table Name  it does not allow more than 30 bytes name   Found another article about 12c R2  which seems to be allowing this up to 128 characters  https   community oracle com ideas 3338

User · Answer

In Oracle 12 2 and above the maximum object name length is 128 bytes   In Oracle 12 1 and below the maximum object name length is 30 bytes

User · Answer

DESCRIBE all tab columns  will show a TABLE NAME VARCHAR2 30   Note VARCHAR2 30  means a 30 byte limitation  not a 30 character limitation  and therefore may be different if your database is configured setup to use a multibyte character set   Mike

User · Answer

Right  but as long as you use ASCII characters even a multibyte character set would still give a limitation of exactly 30 characters    so unless you want to put hearts and smiling cats in you re DB names your fine

User · Answer

The schema object naming rules may also be of some use   http   download oracle com docs cd B19306 01 server 102 b14200 sql elements008 htm sthref723

User · Answer

The maximum length of the table and column name is 128 bytes or 128 characters  This limit is for using sybase database users  I verified this answer thoroughly  so that I have posted this answer confidently

User · Answer

On Oracle 12 2  you can use built-in constant  ORA MAX NAME LEN   set to 128 bytes  as per 12 2  Prior to Oracle 12 1 max size was 30 bytes

User · Answer

Teach a man to fish  Notice the data-type and size   gt describe all tab columns  VIEW all tab columns  Name                                      Null     Type                          ----------------------------------------- -------- ----------------------------  OWNER                                     NOT NULL VARCHAR2 30                   TABLE NAME                                NOT NULL VARCHAR2 30                   COLUMN NAME                               NOT NULL VARCHAR2 30                   DATA TYPE                                          VARCHAR2 106                  DATA TYPE MOD                                      VARCHAR2 3                    DATA TYPE OWNER                                    VARCHAR2 30                   DATA LENGTH                               NOT NULL NUMBER                        DATA PRECISION                                     NUMBER                        DATA SCALE                                         NUMBER                        NULLABLE                                           VARCHAR2 1                    COLUMN ID                                          NUMBER                        DEFAULT LENGTH                                     NUMBER                        DATA DEFAULT                                       LONG                          NUM DISTINCT                                       NUMBER                        LOW VALUE                                          RAW 32                        HIGH VALUE                                         RAW 32                        DENSITY                                            NUMBER                        NUM NULLS                                          NUMBER                        NUM BUCKETS                                        NUMBER                        LAST ANALYZED                                      DATE                          SAMPLE SIZE                                        NUMBER                        CHARACTER SET NAME                                 VARCHAR2 44                   CHAR COL DECL LENGTH                               NUMBER                        GLOBAL STATS                                       VARCHAR2 3                    USER STATS                                         VARCHAR2 3                    AVG COL LEN                                        NUMBER                        CHAR LENGTH                                        NUMBER                        CHAR USED                                          VARCHAR2 1                    V80 FMT IMAGE                                      VARCHAR2 3                    DATA UPGRADED                                      VARCHAR2 3                    HISTOGRAM                                          VARCHAR2 15

User · Answer

In the 10g database I m dealing with  I know table names are maxed at 30 characters  Couldn t tell you what the column name length is  but I know it s   30

User · Answer

Oracle database object names maximum length is 30 bytes   Object Name Rules  http   docs oracle com database 121 SQLRF sql elements008 htm

User · Answer

The maximum name size is 30 characters because of the data dictionary which allows the storage only for 30 bytes

[oracle] What is the maximum length of a table name in Oracle?

Examples related to oracle

Examples related to name-length