oracle错误(三) ORA-00972 identifier is too long 的解决办法
来源:互联网 发布:mac 不能更新10.11.6 编辑:程序博客网 时间:2024/05/22 17:33
今天在oracle数据库,建表时,报错了,信息如下:
解决办法:
原因在于字段超过了Oracle本身设定的30个字符.
如:修改之前的sql脚本: 执行这语句,会报错
-- Create sequence create sequence CMS_ARTICLS_ SPECIAL_CHANNEL_SEQminvalue 1maxvalue 999999999999999999999999999start with 1increment by 1cache 20;
修改后为:
-- Create sequence 注意:由于这里sequeence的名字超出了oracle数据库本身的限制,已更改过create sequence CMS_AS_CHANNEL_SEQminvalue 1maxvalue 999999999999999999999999999start with 1increment by 1cache 20;
0 0
- oracle错误(三) ORA-00972 identifier is too long 的解决办法
- ORA-00972: identifier is too long
- Hibernate(oracle)下的ORA:A-00972 identifier is too long提示
- 超過 Oracle 的長度限制 ORA-00972: identifier is too long
- An simple issue:ORA-00972: identifier is too long
- ORA-00972: identifier is too long报错的另外一种原因
- ora-12169:Net service name given as connect identifier is too long
- ORA-00904:invalid identifier错误的解决办法
- MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法
- MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法
- 关于"The parameter list is too long"错误的原因
- oracle long转换,ORA-00932的错误
- pl/sql报错:Identifier is too long
- pl/sql报错:Identifier is too long
- oracle ORA-01704: string literal too long
- Quartus “Error: Project too complex: hierarchy path is too long ”的解决办法
- 【Oracle】【FAQ】【SQL语句错误导致】oracle ORA-00904: "***": invalid identifier解决办法
- Oracle ORA-01873: the leading precision of the interval is too small 解决办法
- StringUtils方法全集
- Hadoop中运行Wordcount出现异常
- 工作感悟第一篇(爱的蜕变)
- php开启报错
- photoshop小技巧积累
- oracle错误(三) ORA-00972 identifier is too long 的解决办法
- C++ Primer 学习笔记_5_变量和基本类型(续2)
- MySQL的C++封装
- github文件大小限制
- golang实现set集合,变相实现切片去重
- Android网络编程概述
- Android Init Language
- Count Complete Tree Nodes
- iOS - UIAutomation 记录