Yes, the databases are exactly identical - same scripts to create tablespace, tables, indexes, views, whatever. We are currently in 9i. Replication should be near real time - 15 to 30 minutes are acceptable but not overnight. I can create db link from C to A or B. A and B are remote databases while C is in our data center. So how do I do it. Create readonly snapshots for A and B separately. How do you merge in to C's main table? Or is it possible to have C's table as updateable snapshot which is also a table for its application? Sandeep On 9/20/05, Mark Bole <makbo@xxxxxxxxxxx> wrote: > > Sandeep Dubey wrote: > > Hi, > > > > I have three identical databases say A, B and C. > > Identical tablespaces? Identical schemas? Identical tables, keys, > constraints? > > 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 > > reasons. > > Create dblinks in C for A and B instead. > > Also handing over the stream_admin password of C to A and B to > > 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? > Log Miner? > > 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. > > -- > Mark Bole > http://www.bincomputing.com > > > > -- > //www.freelists.org/webpage/oracle-l >