Is there a limitation of the length of the table name? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Is there a limitation of the length of the table name?

Is there a limitation of the length of the table name?# Database - 数据库

h*r2001-01-17 08:01

1 楼

in Oracel, I meet a problem when I create a table cause the
table name is
above 32, is there a way we can reset the table name to the
value I want?
thanks for any suggestion.

s*e2001-01-17 08:01

2 楼

No way.
The limitation of tabel name is from the definition of
Physical Orcale data block. Every oracle block has a limited
spce to store the referenced table name.
So, you can not have too long table name.

【在 h****r 的大作中提到】

: in Oracel, I meet a problem when I create a table cause the
: table name is
: above 32, is there a way we can reset the table name to the
: value I want?
: thanks for any suggestion.

h*r2001-01-17 08:01

3 楼

supermouse, thanks a lot, I just try to ask this question,
didn't expect
somebody can answer my question cause it is too rare, you
are a real
oracle expert. Thanks again for you share your knowledge to
me.

【在 s********e 的大作中提到】

: No way.
: The limitation of tabel name is from the definition of
: Physical Orcale data block. Every oracle block has a limited
: spce to store the referenced table name.
: So, you can not have too long table name.