Hi
All,
Is it true that I cannot create a materialized view by accessing a
remote table? Here is the syntax for creating the materialized view but it does
not work.
REM
Create materialized view mast_time_mv
CREATE MATERIALIZED VIEW mast_time_mv
PCTFREE 0 TABLESPACE mviews_tb
STORAGE (INITIAL 256k NEXT 256k PCTINCREASE 0)
PARALLEL
BUILD IMMEDIATE
REFRESH FAST
ENABLE QUERY REWRITE
AS
SELECT * from [EMAIL PROTECTED];
CREATE MATERIALIZED VIEW mast_time_mv
PCTFREE 0 TABLESPACE mviews_tb
STORAGE (INITIAL 256k NEXT 256k PCTINCREASE 0)
PARALLEL
BUILD IMMEDIATE
REFRESH FAST
ENABLE QUERY REWRITE
AS
SELECT * from [EMAIL PROTECTED];
Where
WHST.TEST.CORP.ICI.COM is database link.
Thanks,
Ashoke