Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Replication ...
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:33:35 CST