Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insert into Materialized View
Hi,
We're pretty new at using Materialized Views, so.......
We have a materialized view: SPECIAL_TST. It seems that the base table also has the same name. So, when I try and insert, I get an ORA-01732. First I guess I want to know where the source is which made the materialized view, which dictionary table? Next, how to insert my values. Do I need to drop the view and re-create it?
Thanks. Received on Mon Dec 12 2005 - 08:15:38 CST