Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01779: cannot modify a column which maps to a non key-preserved table (Oracle 10.2.0.4 ,linux)
ORA-01779: cannot modify a column which maps to a non key-preserved table [message #430199] Mon, 09 November 2009 07:51 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

we got ORA-01779: cannot modify a column which maps to a non key-preserved table error while inserting data into into table.

<<code>>
INSERT INTO (SELECT rp.product_group_id AS rt_product_group_code,
product_group_name AS rt_product_group_name,
rp.last_updated_by, rp.last_updated_timestamp, rp.active,
rtp.product_code
FROM rt_product_group rp,
(SELECT product_group_id,
wm_concat (va_product_code) AS product_code
FROM rt_product_group_product
GROUP BY product_group_id) rtp
WHERE rp.product_group_id = rtp.product_group_id)
(rt_product_group_code, rt_product_group_name, last_updated_by,
last_updated_timestamp, active
)
VALUES ('ABC', 'ABC', 'rmadmin',
TO_DATE ('11/9/2009 18:16:41', 'MM/DD/YYYY HH24:MI:SS'), 'Y'
)
<<code/>

Please help me how to resolve this issue
Re: ORA-01779: cannot modify a column which maps to a non key-preserved table [message #430203 is a reply to message #430199] Mon, 09 November 2009 08:19 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search BEFORE posting.
This question has been asked each week this month and hundred of times on the web..

Regards
Michel
Previous Topic: Oracles Alternative For SQLServers Cross Apply (merged)
Next Topic: Using "with as" in a select statment.
Goto Forum:
  


Current Time: Sat Dec 03 18:04:59 CST 2016

Total time taken to generate the page: 0.14617 seconds