错误日志记录

错误记录：

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);