Could I change the max length of an object name?

[gzja...@gmail.com]

Could I change the max length limit(30 characters) of an object name?
If I could, how?

Thank you very much!
Jack.Lee

[gazzag]

No. Why would you want to?

-g

[gym dot scuba dot kennedy at gmail]

<gzja...@gmail.com> wrote in message
news:633be041-26e3-4066...@v26g2000prm.googlegroups.com...

no, you cannot

[Mark D Powell]

My experience tells me it is best if table names are kept to around 20
characters.

Oracle does support some objects with names greater then 30 characters
such as database links, but not table names, index names, column
names, or view_names.

One thing you should do in development is to adopt a common set of
abbreviations that you use all the time even if the length of the
object name is well under 30 characters. Consistency in naming
standard provides significant long-term maintenance benefit.

HTH -- Mark D Powell --

[Mladen Gogala]

No, but you can try mailing this question to Tom Kyte. He's in a really
good mood these days, it must be the heat.

--
http://mgogala.freehostia.com