关于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吧。