| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Pushing changes
If you're on 9iR2, Streams may be an option. We are experimenting w/ it here. Warning, my perception is it's not ready for prime-time. FBIs are unsupported, as are various datatypes, etc.
-Mark
-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
Sent: Thursday, February 26, 2004 2:26 PM
To: 'oracle-l_at_freelists.org'
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |