Re: Replication ...

From: Sandro Décio <sdvidal_at_altavista.net>
Date: Tue, 08 Dec 1998 00:31:30 -0200
Message-ID: <366C8F81.53ECF51C@altavista.net>

Oracle does not recommend that you create trigger on snapshots. You can see when the table was changed (refreshed) looking at user_snapshot or dba_snapshot view on remote instance (where the snapshot read only was created).
bye,
Sandro.

Narendra Nathmal wrote:

> If we use Oracle snapshot replication and replicate a table can one
> write a trigger on the replicated table.
>
> eg : db1.table1 copied(replicated) as a readonly snapshot to
> db2.table1. Can one
> write a trigger on db2.table1 so that we know when the table
> changed and what changed.
>
> Any experiences ? Feedback appreciated.
>
> Thanks
>
> -Naren

Received on Mon Dec 07 1998 - 20:31:30 CST