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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Update statement using a join on a materialized view

Re: Update statement using a join on a materialized view

From: Andy <andrewfaseuk_at_hotmail.com>
Date: 14 Mar 2006 23:34:08 -0800
Message-ID: <1142408048.360269.167440@u72g2000cwu.googlegroups.com> 






> >

> > 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 .....
Received on Wed Mar 15 2006 - 01:34:08 CST












Original text of this message













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