ORA-01438: value larger than specified precision allowed for this column
来源:互联网 发布:空调推荐 知乎 编辑:程序博客网 时间:2024/05/19 03:28
ORA-01438: value larger than specified precision allowed for this column
明眼一看就知道时字段长度不够
insert into oss_addr_mon_stats_tmp06
select /*+use_hash(a,c)*/
provcode,
areacode,
count(a.serialid) as self_group_serial_num --统计自定义分组的联系人人数 tmp06
from oss_addr_mon_stats_tmp05 a
inner join oss_addr_mon_stats_tmp04 c on a.usernumber=c.usernumber and a.groupid=c.groupid
group by provcode,areacode;
从生产库里跑这个语句,从结果上看没有数据太长啊,
并把结果拷到开发库里的对应表,插入也正常
-- Create table
create table OSS_ADDR_MON_STATS_TMP06
(
SELF_GROUP_SERIAL_NUM NUMBER(10) default 0,
PROVCODE NUMBER(5) not null,
AREACODE NUMBER(5) not null
)
看下表结构 插入顺序反了 记一过
- ORA-01438处理方法 value larger than specified precision allowed for this column
- ORA-01438: value larger than specified precision allowed for this column
- ora-01438:value larger than specified precision allowed for this column
- ORA-00823: Specified value of sga_target greater than sga_max_size
- ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
- Packets larger than max_allowed_packet are not allowed
- ORA-12899: value too large for column
- ORA-12899: value too large for column
- mysql Packets larger than max_allowed_packet are not allowed
- MYSQL报错“Packets larger than max_allowed_packet are not allowed”
- Mysql 报错Packets larger than max_allowed_packet are not allowed
- getString() always return 255 when column is larger than 255
- ORA-12899 – Value too large for column string
- goldengate ORA-12899: value too large for column
- ORA-14185: incorrect physical attribute specified for this index partition
- no column name was specified for column
- ORA-24323: value not allowed ORA-01089
- An explicit value for the identity column in table 'users' can only be specified when a column list
- Linux study Note
- Linux统计某文件夹下文件、文件夹的个数
- SqlCommand对象 ExecuteReader,ExecuteNonQuery,EXecuteScalar
- FLX6410上调试Marvell 88W8787 SDIO WIFI
- document.getElementById("baidu") .innerHTML 详解剖析
- ORA-01438: value larger than specified precision allowed for this column
- struts下载遇到错误
- 推荐引擎基本知识
- mysql之删除重复数据
- 新手学习ad hoc网络
- linux下利用valgrind工具进行内存泄露检测和性能分析
- android如何浏览并选择图片 音频 视频 转
- 根据OSTU大津法使用Matlab实现数字图像处理segmentation的graythresh函数
- vm下linux的常见问题