Re: How to record changes in snapshot?

From: Eugene Gardner <Gene_at_VaxMan.prestel.co.uk>
Date: Thu, 07 Jan 1999 18:12:57 GMT
Message-ID: <3694e028.26823941@news.prestel.co.uk>

Fire off a trigger. Snapshot logs work by use of an AFTER ROW trigger on the table. I'm not sure if modifying the Oracle created trigger is a supported operation, but creating a BEFORE ROW trigger would be.

Eugene.

---

"Artur" <parafiniuk_at_hotmail.com> wrote:

> Hi all,
>
> I wonder how can I record changes in my fast refresh snapshot, where only
> updates are populated. I need to know what was changed in master table - any
> delete, insert or update, if so then which records and fields. Is snapshot
> log anyhow helpful in that? If not, what is the solution?
>
> I appreciate any hints.
>
> Thanks a bunch!
> Artur
>
>
Received on Thu Jan 07 1999 - 12:12:57 CST