| Conditional Replication Streams [message #311234] |
Thu, 03 April 2008 16:29  |
mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA
|
Member |
 
|
|
Dear Guru
I have setup 3 databases(A,B,C).I configured Streams(Bi-directional repllication) in 3 databases.And worked fine.
I face some problems, please take my query.I will be very happy if I get solution.
A.(problem 1)
I want to know Can I Configure conditional DML in streams? i.e I have 3 databases , one database(A) is for all data,rest of database(B,C) are subset of data.
Scenario: Can it Possible by Streams
1.Suppose in Database 'A' , one DML(Insert,Update) operation execute for Database 'B' not Database 'C' . Data will find A and B only .
2.Suppose in Database 'A' , one DML(Insert,Update) operation execute for Database 'C' not Database 'B' . Data will find A and C only .
3.In database 'C' ,one DML(Insert,Update) statement operation execute for Database 'A'.
Data will find 'C' and 'A' only .
4.In database 'B' ,one DML(Insert,Update) statement operation execute for Database 'A'.
Data will find 'B' and 'A' only .
5.Some cases in Databases 'A',one DML (Insert,Update) statement operation execute for Database 'B' and 'C'.
Data will find 'A' 'B'and 'C'.
B.(problem 2)
How many sites(Databases) can be added in streams Environment? any restriction (number of databases) ?
With Regards
Asraf
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
