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

Home -> Community -> Usenet -> c.d.o.server -> complete refresh of large materialized view, online or any alternatives?

complete refresh of large materialized view, online or any alternatives?

From: Hendrik Lampert <henhouse_at_gmx.net>
Date: Thu, 17 Jul 2003 13:01:06 +0200
Message-ID: <bf5vm3$5c9$02$1@news.t-online.com> 





hi,



using dbms_snapshot.refresh ('mview', 'C') takes about half an hour to
complete. During that procedure the table is empty. The refresh runs every
day in the morning  when users would like to query the table.



Are  the any solutions to get  the materialized view refreshed online
without having the table empty?



many thanks


hendrik
Received on Thu Jul 17 2003 - 06:01:06 CDT












Original text of this message













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