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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Materialized views with fast refresh

Re: Materialized views with fast refresh

From: Thomas Day <tomday2_at_gmail.com>
Date: Fri, 21 Apr 2006 11:44:28 -0400
Message-ID: <a8c504590604210844h1a41a008uba48e6a2e8c4768b@mail.gmail.com> 





Create the view on the snapshot database.  As the error message says, you
cannot snapshot complex queries.  Also, I'd use primary keys instead of
rowids.  Keeps you from having to re-build the snapshots every time you move
(as opposed to change) the source data.  But that's just me.


--
http://www.freelists.org/webpage/oracle-l


Received on Fri Apr 21 2006 - 10:44:28 CDT












Original text of this message













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