I have three identical databases say A, B and C.
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.
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?
data from remote database to your data center? Seems like streams push technology is a security hole.
-- Mark Bole http://www.bincomputing.com