Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Probably a simple INSERT operation question

Probably a simple INSERT operation question

From: Bruce C. Miller <bm3719_at_gmail.com>
Date: 3 Jan 2007 06:55:49 -0800
Message-ID: <1167836149.420364.89030@42g2000cwt.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US