Skip to Main Content
Forums

SQL & PL/SQL

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!

Maximum length of Field/Table Name

533682Mar 7 2008 — edited Mar 7 2008
Hi All,
Currently I need to rename a table (TableName) in my SQL script. May I know the maximum length allow to rename the table? FYI, I am using database 10G release 2. My db does only allow me to use up to char 30. Is there a place for me to change the setting for Max char allowed?

EG : SELECT * FROM Table1 TableName
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2008
Added on Mar 7 2008
4 comments
395 views