Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
General Database Discussions
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 19, 2013 2:53 AM by
Oracle database object name 30 characters limit
Feb 19, 2013 2:46 AM
I'm working with Oracle since version 8 and I know about this restriction. I was hopping that this will be eliminated in the future, but I saw that in Oracle 11i the same restriction exists.
Does anyone know if it will be eliminated in a future release?
I would like to know if there is a reason why this limitation exists. We are currently developing an JPA application and we have tables that have name with more than 30 characters.
This content has been marked as final.
Show 1 reply
Re: Oracle database object name 30 characters limit
Feb 19, 2013 2:53 AM
in response to
because all table/index names must be stored in the data dictionary and that storage is only allocated for 30 characters