Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Problem with Materialized Views

Problem with Materialized Views

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Thu, 12 Oct 2000 14:25:06 -0700
Message-Id: <10647.119114@fatcity.com> 





Hi!



I'm fairly new to materialized views... Why can't I create this MV (the
error message description doesn't help much).



Create Materialized View MVTabs


BUILD IMMEDIATE REFRESH ON COMMIT



as


SELECT * FROM TBTABS WHERE TABSTATUS=3;



Thanks,
Received on Thu Oct 12 2000 - 16:25:06 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US