Home » Other » Test » Conditional Replication Streams (Oracle 10g Release 2, Windows 2003 server)
Conditional Replication Streams [message #311234] Thu, 03 April 2008 16:29 Go to next message
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
Re: Conditional Replication Streams [message #311248 is a reply to message #311234] Thu, 03 April 2008 17:35 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
The question has been raised in http://www.orafaq.com/forum/m/311231/67467/#msg_311231

David
Previous Topic: test
Next Topic: Show Sum
Goto Forum:
  


Current Time: Thu Mar 28 06:22:01 CDT 2024