Frank van Bortel wrote:
> 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
Or for a single MV (or comma-separated list or DBMS_UTILITY.UNCL_ARRAY
collection), DBMS_MVIEW.REFRESH('mview list')
Received on Sat Jun 11 2005 - 17:39:19 CDT
