Home » RDBMS Server » Server Administration » Max size of table and column names
Max size of table and column names [message #54480] Tue, 19 November 2002 12:32 Go to next message
Rene Mendes
Messages: 4
Registered: November 2002
Junior Member
It is possible to edit the maximum size (currently varchar2(30)) of table and column names in Oracle9i? How to perform this?

Report message to a moderator

Re: Max size of table and column names [message #54483 is a reply to message #54480] Tue, 19 November 2002 13:33 Go to previous messageGo to next message
Kossaku Nakombi
Messages: 12
Registered: November 2002
Junior Member
You can modify the size of columns but not they name. You have to drop (table or column) and recreate it.

Report message to a moderator

Re: Max size of table and column names [message #54504 is a reply to message #54480] Wed, 20 November 2002 04:35 Go to previous message
Rene Mendes
Messages: 4
Registered: November 2002
Junior Member
My doubt if relates to the possibility to increase the maximum limit of 30 characters for table and field names in Oracle9i. That is possible? That is, if I need to create tables or fields having names with more than 30 characters, how to perform this?

*****************
Minha dúvida se refere à possibilidade de aumentar o limite máximo de 30 caracteres para nomes de campos e tabelas imposto pelo Oracle. Isto é possível ? Isto é, se eu precisar criar um nome de tabela ou campo com mais de 30 caracteres, como farei ?

Report message to a moderator

Previous Topic: Oracle settings printout
Next Topic: Increase the maximum limit for table and column names in Oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:25:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.