Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Probably a simple INSERT operation question
If I have a table that has no primary key (in my case, just two
columns, one non-nullable), how do I perform an INSERT into it? If I
just do a:
INSERT INTO T1(V1, V2) VALUES('test', 'ghey');
I get an error ORA-01779: cannot modify a column which maps to a non-key-preserved table. Running a search for this ORA error gives the solution "Try updating the tables directly." What kind of statement would I use for that? Received on Wed Jan 03 2007 - 08:55:49 CST
![]() |
![]() |