Re: Probably a simple INSERT operation question

From: What's in a namespace <xml_at_ns.com>
Date: Wed, 3 Jan 2007 16:20:07 +0100
Message-ID: <459bc9a8$0$320$e4fe514c@news.xs4all.nl>

"Bruce C. Miller" <bm3719_at_gmail.com> schreef in bericht news:1167836149.420364.89030_at_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?
>

Looks like you're updating a VIEW, not a TABLE.

Shakespeare Received on Wed Jan 03 2007 - 09:20:07 CST