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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Refresh materialized view

Re: Refresh materialized view

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 11 Jun 2005 10:48:46 +0200
Message-ID: <d8e87r$h2q$1@news2.zwoll1.ov.home.nl> 





Alen Cappelletti wrote:


> Trigger is AFTER INSERT INTO TABLE....

> oracle version is 8.1.7

> 

> I hope U can help me....

> 



No, no on commit refreshes in 817...


You could have a call to dbms_job, and submit a request for
a dbms_refresh.refresh - does refresh the snapshot group, not
just the snapshout (simple: add snapshot to gruop).



Not sure I like the solution, though - it my be very
resource demanding

-- 
Regards,
Frank van Bortel


Received on Sat Jun 11 2005 - 03:48:46 CDT












Original text of this message













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