CREATE MATERIALIZED VIEW : table doesn't exist

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 ? Received on Tue Jan 24 2006 - 09:58:43 CST