Re: snapshots event triggered?

From: C. M. Springer, Jr. <carl_at_junkpile.com>
Date: Thu, 19 Nov 1998 15:11:23 -0500
Message-ID: <36547B6A.B306D8E7@junkpile.com>

Would it work to put a trigger on the table (for whatever operation is appropriate) that calls the dbms_snapshot.refresh procedure for the desired snapshot?

I have not tried this, but the thought came to mind.

Roman wrote:

> Does anyone know, how to make snapshots to be event triggered instead of
> time triggered?
>
> My aim:
> the execution of a snapshot (the next statement) should not be in a fixed
> period but if the contents of a specific table changed.
>
> How should it be done?
>
> Thanks for any help!
Received on Thu Nov 19 1998 - 14:11:23 CST