Re: View problem - cannot update with a Join

When you create your view, have you made your view 'read only'? Or do you have any privilege to change the base tables under the views? If you have all the privilege to the two base tables and you did not made your view read only, I never heard of such a situation happening.

Another way to get around is to write trigger on one of the table, so that everytime when it got update/delete/insert, it will fire a trigger and update/delete/insert on another table

Winnie

Mark Tortolano wrote in message <35f4cd09.10345569_at_news.supernews.com>...
>Hi,
>
>I have a view in my database that used to represent the fields in a
>single table of user preferences. Now, however, I want to split that
>user preferences table into two parts, so that the core preferences
>(eg user email, name) are in one table, and their other preferences
>(numerous, less important fields) are held in another table. There
>will be a one-to-one relationship between these tables.
>
>I created the two tables using existing data from the one table, and
>made sure that the other preferences table references the main
>preferences table. I now realise, however, that Oracle will not let me
>make a view updateable when the view is created using a join, even if
>- it seems - the relationship between the tables is one-to-one.
>
>Is there an easy way around this, or do I have to go right through my
>application turning each UPDATE, INSERT, or DELETE into two separate
>SQL statements. This will be a real pain!
>
>Thanks,
>
>Mark Tortolano
Received on Mon Sep 07 1998 - 00:00:00 CDT