CREATE MATERIALIZED VIEW B.MV
REFRESH COMPLETE ON DEMAND
AS
SELECT *
FROM B.V
as the tables are owned by schema 'A' why it is "... FROM B.V", it should be 'A.V' ?