ora-01440:column to be modified must be empty to decrease precision or scale
来源:互联网 发布:r软件介绍 编辑:程序博客网 时间:2024/05/17 00:06
问题缘由:
客户要求某个字段支持小数点,数据库一开始设计的时候只支持整数,在通过alert语句修改类型,出现了ora-001440的错误,
解决办法
step1:备份原来的表,
create table WF_TEACHER_REMUNERATION_BAK
as select * from WF_TEACHER_REMUNERATION;
step2:删除原来表的数据
delete from
WF_TEACHER_REMUNERATION
;
step3:修改精度
ALTER TABLE "DHOFFICE"."WF_TEACHER_REMUNERATION"
MODIFY ( "CLASS_TIME" NUMBER(10,2) ) ;
step4:恢复数据
insert into
WF_TEACHER_REMUNERATION
select * from
WF_TEACHER_REMUNERATION_BAK
;
step by step ,打完毕,收工!
- ora-01440:column to be modified must be empty to decrease precision or scale
- oracle : olumn to be modified must be empty to decrease precision or scale
- ORA-01439: column to be modified must be empty to change datatype
- ORA-01758: table must be empty to add mandatory (NOT NULL) column
- ORA-01442: column to be modified to NOT NULL is already NOT NULL
- ORA-01442: column to be modified to NOT NULL is already NOT NULL
- must be caught or declared to be thrown
- According to TLD, tag bean:write must be empty
- According to TLD, tag s:property must be empty
- Name for parameter binding must not be null or empty! On JDKs < 8, you need to use @Param for named
- To be or not
- To be or not to be
- To be or not to be
- To be or not to be
- TO BE OR NOT TO BE
- To be or not to be
- To Be or Not To Be
- to be or not to be
- 检入模型导致关联部件属性值丢失
- sql*plus中的几种格式化命令
- 红色和蓝色混淆
- JDK1.5中的线程池(java.util.concurrent.ThreadPoolExecutor)使用简介,线程邮件发送实例
- vba操作IE浏览器
- ora-01440:column to be modified must be empty to decrease precision or scale
- web ui 前端框架 easyui extjs dwz dojo等简单对比
- 使用多线程的利弊
- 关于人脉的逻辑,和个人处世的逻辑(转)
- Spring最简单的Java Project Demo
- 微型抢占式多任务实时内核设计
- java 与 C++ 区别
- FastReport FAQ
- linux wait_event and wake_up