Re: How to record changes in snapshot?

Hello,

U can investigate the snapshot log. What u can get from it is the rowid and change type (update delete or insert).
If this information is not enough, u can log your own information using triggers on the master table.
Oracle implicitly does it, creating triggers to update the snapshot log. U can add your own logging there.

Artur 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 14 1999 - 15:11:18 CST