由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Is there a limitation of the length of the table name?
相关主题
产生ORACLE TABLE 的问题orcale 10g的问题
请教sql server temptable # 和 ##Oracel, My SQL是不是case sensitive?
truncate和delete在ORACLE里有什么区别?dba interview 都问些啥
求教如何针对这种情况进行优化how to write this trigger
Import a text file into Oracle...申请一FINANCIAL 的职位.和经理, VP 上周面完了.
question about SQL*LOADER咋样选一个表中在另一个表中不含有的记录
Oracle not available - what's that mean?求教...初级问题
[转载] 还是Oracle用得多呀, 哪里有入门教程?how to see all the tables in SQL*PLUS?
相关话题的讨论汇总
话题: table话题: name话题: limitation话题: length话题: oracel
进入Database版参与讨论
1 (共1页)
h****r
发帖数: 2056
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********e
发帖数: 62
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****r
发帖数: 2056
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.

1 (共1页)
进入Database版参与讨论
相关主题
how to see all the tables in SQL*PLUS?Import a text file into Oracle...
foreign key reference to two tables? how to do it?question about SQL*LOADER
how to list all tables in my account?Oracle not available - what's that mean?
Can I create thousands table in one...[转载] 还是Oracle用得多呀, 哪里有入门教程?
产生ORACLE TABLE 的问题orcale 10g的问题
请教sql server temptable # 和 ##Oracel, My SQL是不是case sensitive?
truncate和delete在ORACLE里有什么区别?dba interview 都问些啥
求教如何针对这种情况进行优化how to write this trigger
相关话题的讨论汇总
话题: table话题: name话题: limitation话题: length话题: oracel