dbTalk Databases Forums  

Multi-Source streams Replication

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Multi-Source streams Replication in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ora_DBA
 
Posts: n/a

Default Multi-Source streams Replication - 03-20-2010 , 06:38 AM






Can streams replication be used for multi-source replication ?

I have 5 source databases. I would like to replicate 1 schema from
each of these databases into a target database. The target database
will have 5 distinct schemas, one for each source schema.

Is it possible to do this using Streams Replication ? If yes, then are
there any performance or any other issues for this type of
configuration.

Thanks.

Reply With Quote
  #2  
Old   
Michel Cadot
 
Posts: n/a

Default Re: Multi-Source streams Replication - 03-20-2010 , 09:45 AM






"Ora_DBA" <sanjaydharmadhikari (AT) gmail (DOT) com> a écrit dans le message de news:
7221f1c1-ff8c-448c-89cd-5b9602e33954...oglegroups.com...
Quote:
Can streams replication be used for multi-source replication ?

I have 5 source databases. I would like to replicate 1 schema from
each of these databases into a target database. The target database
will have 5 distinct schemas, one for each source schema.

Is it possible to do this using Streams Replication ? If yes, then are
there any performance or any other issues for this type of
configuration.

Thanks.
Yes it is possible (it is evenn possible to replicate all in one schema).

Performances problems are the same one that in any Streams configuration.

Regards
Michel

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.