as the tables are owned by schema 'A' why it is "... FROM B.V", it should be 'A.V' ?CREATE MATERIALIZED VIEW B.MV
REFRESH COMPLETE ON DEMAND
AS
SELECT *
FROM B.V
|
Results 1 to 5 of 5
Thread: Refresh MV on demandThreaded View
|
Click Here to Expand Forum to Full Width |