日期:2014-05-16 浏览次数:20643 次
解决方案是: insert into CY_PROP_REASON select * from CY_PROP_REASON_INSERT; 这一句改成 insert into CY_PROP_REASON(ID, CREATETIME, UPDATETIME, VERSION, BSC, MO, RESON_ATTRIBUTE, FAULT_TYPE, FAULT_TYPE2, FAULT_LEVEL, FAULT_OBJECT, FAULT_DESCRIPTION, TTIME, THOUR, REGION, TOWN, SUM_FLAG, LABEL, CH_RAT, TOPN, PRI, CURRENT_INDEX_VALUE, PI_COLUMN )select ID, CREATETIME, UPDATETIME, VERSION, BSC, MO, RESON_ATTRIBUTE, FAULT_TYPE, FAULT_TYPE2, FAULT_LEVEL, FAULT_OBJECT, FAULT_DESCRIPTION, TTIME, THOUR, REGION, TOWN, SUM_FLAG, LABEL, CH_RAT, TOPN, PRI, CURRENT_INDEX_VALUE, PI_COLUMN from CY_PROP_REASON_INSERT;