I don't think snapshots can work the way you want. They use a select
statement on the snapshot side. You may have to look into advanced
replication -- although I have no knowledge or experience of such things.
You could set up a database link to the remote database (instead of a
snapshot) and update the remote tables directly, perhaps having database
triggers do the replication -- then again, I think this is just a narrow
picture of a bigger world.
"Steve Janiak" <sjaniak_at_mitre.org> wrote in message
news:38A0C706.95866391_at_mitre.org...
> Is it possible to schedule initiation of the requests from the Master
> site instead of from the snapshot site, therefore, eliminating the need
> for the snapshot site to send any communications to the master site?
> The only port I am allowed to keep open is the one from the master site
> to the snapshot site. The port from the snapshot site to the master
> site will be closed. I am using snapshot logs on the master site for
> fast replication.
>
> Security warrants this question since I am moving the snapshot site
> outside our firewall?
>
> thanks
Received on Thu Feb 10 2000 - 00:17:59 CST
