Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there any way to overcome length limit of table name ?

thrupassMay 9 2016 — edited May 10 2016

Hi, experts

ORACLE : 12.1.0.2

SQL> desc dba_tables;

Column                         Nullable Type                         Comment                                           

------------------------------ -------- ---------------------------- --------------------------------------------------

OWNER                          NOT NULL VARCHAR2(128)                Owner of the table                               

TABLE_NAME                     NOT NULL VARCHAR2(128)                Name of the table   

....

SQL> create table a012345678901234567890123456789 (c1 char(10));

ORA-00972: identifier is too long

why is the length of table_name in dba_tables 128 ?

Is there any way to increase length limit of table name ?

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2016
Added on May 9 2016
4 comments
272 views