Re: CREATE MATERIALIZED VIEW : table doesn't exist

News wrote:
> SELECT * FROM A, B;
>
> gives results but
>
> CREATE MATERIALIZED VIEW test
> BUILD immediate
> REFRESH complete ON DEMAND
> AS
> SELECT * FROM A,B ;
>
> ORA-00942: table or view does not exist
>
> There's no views, public or private synonyms named A, B. Tables and MV
> are owned by the same schemas where CREATE MATERIALIZED VIEW is issued.
> Any idea ?

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 24 09:24:08 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> create table a (

   2 testcol VARCHAR2(10));

Table created.

SQL> create table b (

   2 newcol VARCHAR2(10));

Table created.

SQL> select * from a,b;

no rows selected

SQL> CREATE MATERIALIZED VIEW test

   2 BUILD immediate
   3 REFRESH complete ON DEMAND
   4 AS
   5 SELECT * FROM A,B ; Materialized view created.

SQL> Something is not as you assume. Recheck your assumptions.

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