Home » Server Options » Replication » Single Master Replication
Single Master Replication [message #289736] Tue, 25 December 2007 23:24 Go to next message
arthik_babu
Messages: 8
Registered: December 2007
Junior Member
Hi ,

Is it possible to create replication on same database with different schema ?

Thanks in advance

Report message to a moderator

Re: Single Master Replication [message #289738 is a reply to message #289736] Tue, 25 December 2007 23:37 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
Why not ..possible in many ways .. if you want to setup replication using the materialized views concept . then create a public synonym for the object you want to replicate and then create the materialized view in the schema where you want the object to be replicated.

Ex:
create materialized view samplerep
refresh complete on demand
as
select col1, col2, col3 from A.table1;

-Sai Jeedigunta

Report message to a moderator

Previous Topic: Help in Replication, step to create updateble M.V.
Next Topic: Pls Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 11:46:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.