RE: Pushing changes
- From: "QuijadaReina, Julio C" <QuijadJC@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Feb 2004 09:32:30 -0500
Patrice,
You could copy the archived redo logs from your intranet db server out
to the DMZ db server. Then, you can use those redo logs to bring your
DMZ db server up to date. Just a thought...
Cheers,
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Boivin, Patrice J
Sent: Thursday, February 26, 2004 2:26 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Pushing changes
I have a question.
We plan to implement a db server in a DMZ, but the data to populate it
will
come from another machine in our intranet.
All changes have to be initiated from within the intranet and pushed
outward.
That means the db server in the intranet has to push data to the server
in
the DMZ.
The data to be pushed changes; usually the users add rows, but sometimes
they update or delete rows.
The replication method has to be able to log these changes and make them
on
the remote machine.
Ideally the replication method would only transfer changes, not the
whole
thing -- this dataset is going to be in the gigabytes in size.
Also the replication can't be done through triggers, because users
typically
add records by doing data loads.
My problem is, materialized views usually pull info in, don't they? I
like
what MVIEWS can do but I need to push, not pull.
Pulling data into the DMZ server is not an option.
Can anyone point me in the right direction?
Patrice.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
