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 -> Re: complete refresh of large materialized view, online or any alternatives?

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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 17 Jul 2003 20:12:04 +0200
Message-ID: <3mpdhvgn0stgovj41ht8gpg4qua4v65ivv@4ax.com> 





On Thu, 17 Jul 2003 13:01:06 +0200, "Hendrik Lampert"
<henhouse_at_gmx.net> wrote:



>Are  the any solutions to get  the materialized view refreshed online

>without having the table empty?





Sure : tune the underlying sql statement, buy a faster server,
increase the shared pool or the buffer cache, or whatever symptom
fighting alternatives you can think of.




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Thu Jul 17 2003 - 13:12:04 CDT












Original text of this message













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