| is it possible ? [message #404929] |
Mon, 25 May 2009 09:30  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello is is possible to use oracle replication for the following :
i have a databse in site A
and 4 database in sites B,C and D
is it possibles to use Oracle replication in order to have all tables data from sites B,C and D in relevant table in Site A,
assuming that site A tables has the site id in each of its tables
hope i was clear
thanks
|
|
|
|
|
|
| Re: is it possible ? [message #405024 is a reply to message #404929] |
Tue, 26 May 2009 01:59  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
Thanks Michel
just to be more clear:
on site A I have a table name t1, with this structure
site id, order id . client id, date
------- -------- --------- ----
A 1 2 22-3-09
B 1 5 23-5-09
C 3 8 12-5-09
i have the same table in all other sites B,C and D
but with data only specific to the site example:
site B:
site id, order id . client id, date
------- -------- --------- ----
B 1 2 22-3-09
B 1 5 23-5-09 B 3 8 12-5-09
so what I need is to have all this data from the 3 sites B,C and D replicate in the same table t1 in site A, real time or not it does not matter
so does oracle streams solve it ?
many thanks
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
