RE: Materialized View

[Abdul Aleem]

Title: RE: Simple question on logging..

Not sure but I think you need to have Enterprise Edition for that. Otherwise it should work fine   Aleem   -----Original Message----- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:18 AM To: Multiple recipients of list ORACLE-L Subject: Materialized View   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];   Where WHST.TEST.CORP.ICI.COM is database link.   Thanks, Ashoke