Re: Replication question
- From: Mark Bole <makbo@xxxxxxxxxxx>
- Date: Tue, 20 Sep 2005 07:50:00 -0700
Sandeep Dubey wrote:
I have three identical databases say A, B and C.
Identical tablespaces? Identical schemas? Identical tables, keys,
I want to replicate
from A and B to C. Meaning C will have its own data plus the data from A
and B. I can not create a db link from A or B pointing to C for security
Also handing over the stream_admin password of C to A and B to
Create dblinks in C for A and B instead.
push their changes through streams is not very good idea. I can not have
multimaster replication as C is not sending its change to A or B.
Please suggest how this can be done?
You didn't mention version. Transportable tablespaces? Export/Import?
Is any one using streams to capture
data from remote database to your data center? Seems like streams push
technology is a security hole.
Any method of taking data out of one database and loading it into
another is going to have security issues, especially if you want it to
run unattended. Your management needs to decide what level of risk they
will accept to achieve a certain level of benefit.
Other related posts: