当前位置: 代码迷 >> Oracle技术 >> 关于ORA-01779: cannot modify a column which 地图s to a non key-preserved table
  详细解决方案

关于ORA-01779: cannot modify a column which 地图s to a non key-preserved table

热度:153   发布时间:2016-04-24 08:25:15.0
关于ORA-01779: cannot modify a column which maps to a non key-preserved table
在oracle中输入
insert into tcm_od_objects (ne_id, zh_label, userlabel, ne_type, vendor_id, confirmed, province_name, city_name, artificial_flag, pcode, version)
  2 values (2012081701, '陕西实际数据入库测试网元', '陕西实际数据入库测试网元', 'MSC_Server', '1', 0, '陕西', '西安市', 0, '29', 'R12'); 
出现了ORA-01779: cannot modify a column which maps to a non key-preserved table 提示
谁在不明白错哪里了 ,求大神拯救!

------解决方案--------------------
tcm_od_objects 是个视图,改成对基表直接INSERT吧。
  相关解决方案