且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

错误日志记录

更新时间:2022-09-21 17:47:44

错误记录:

OBJECTS_INTEGRITY
----------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR SYNONYM: EC_TURBINE_OUTAGE_SCADA DOES NOT EXIST !

这是为FC留的接口,如果没有FC,则会报这个错误。

 

pk_column_info不存在的错误

--首先查询是否有重复记录
select table_id,column_id,count(*) cnt from column_info t group by table_id,column_id having count(*)>1;

--删除这条重复记录
delete from column_info where table_id=172 and column_id=64 and column_name_eng='plan_64';
commit;

--再次查询,如果查询结果为0表示已经删除掉了
select table_id,column_id,count(*) cnt from column_info t group by table_id,column_id having count(*)>1;

--执行添加主键操作
alter table column_info add constraint pk_column_info primary key(table_id, column_id);

 

 

 本文转自xwdreamer博客园博客,原文链接:http://www.cnblogs.com/xwdreamer/p/3431066.html,如需转载请自行联系原作者