Re: Manually Replicating a Database

Kevin Bongiovanni (bong_at_fwb.gulf.com) wrote:
: I have two machines that are using the same stand-alone Oracle database.
: In the past, one machine was the master database and the other machine a
: snapshot database. Recently, somebody decided to make life difficult.
: Both machines are processing data that the other machine needs to know
: about. Worst, nobody want to pay to network them and other things that
: will make life easy. I'm afraid, I'm forced into floppy disk
: replication.

BE Afraid, Be very afraid.

: OK, How do I update the two Oracle 6 databases so that both databases are
: current. To make life simple, Let's just talk about a table (Unless the
: EXP program can be used somehow).
 

: Please Help.
 

: Kevin
: bong_at_fwb.gulf.com

This sounds like a job for Pro*<your favorite language>. You will have to come up with the business rules for which data the other box 'needs' to know about, then either export the whole thing from one side, then import ( Customized exp and imp ) the desired rows into the other side, or if possible, only export the desired rows and then import everything to the other side.

Problems will include the size of the files - you may need several disks, and timeliness of the data transfer - how often will you be doing the move.

My advice is to fight harder for the network...

Randy

--

_/_/_/_/  _/     _/  _/      _/  _/_/_/  _/_/_/_/   _/_/_/    _/_/_/
_/        _/_/   _/   _/     _/    _/    _/    _/  _/    _/  _/    _/
_/_/_/    _/ _/  _/    _/   _/     _/    _/_/_/    _/        _/    _/
_/        _/  _/ _/     _/ _/      _/    _/        _/        _/    _/
_/_/_/_/  _/   _/_/      /_/     _/_/_/  _/         _/_/_/   _/_/_/
=====================================================================
    Randy DeWoolfson  -  ergo sum    :-)        envipco_at_cais.com
 or Ron Frederick     -  ergo ?      (8P
---------------------------------------------------------------------
#include <StandardDisclaimerOnOpinions>  // Null if file not found.
=====================================================================