Re: Update statement using a join on a materialized view

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 15 Mar 2006 08:58:30 -0800
Message-ID: <1142441888.894678@yasure.drizzle.com>

Andy wrote:

>>> Andy
>> You are executing an UPDATE statement.
>> --

>
> But only actually updating Table_A NOT the materialised view, its just
> used in the select part of the update statement. This is really my
> question ... I assume the naswer is I need update permissions on the
> materialised view, which I did'nt know was possible .....

Argue or pleading with me won't change a thing.

It is as it is and your path to a solution is quite clear.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Mar 15 2006 - 10:58:30 CST