Re: CREATE MATERIALIZED VIEW : table doesn't exist

"News" <Contact_404_at_hotmail.com> a écrit dans le message de news: 1138118323.013131.223060_at_z14g2000cwz.googlegroups.com...
| 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 ?
|

Did you read the first line of prerequisites for create materialized view? Is this true?

Regards
Michel Cadot Received on Tue Jan 24 2006 - 11:29:13 CST