Materialized View

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Wed, 14 Aug 2002 16:18:22 -0800
Message-ID: <F001.004B55EF.20020814161822@fatcity.com>

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 MAST_TIME_at_WHST.TEST.CORP.ICI.COM;  

Where WHST.TEST.CORP.ICI.COM is database link.  

Thanks,
Ashoke

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mandal, Ashoke
  INET: ashoke.k.mandal_at_medtronic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 14 2002 - 19:18:22 CDT