| schema-level replication [message #75404] |
Tue, 04 November 2003 02:17  |
Sushma MV
Messages: 4
Registered: November 2003
|
Junior Member |
|
|
|
I have exactly similar databases on 2 different hosts. I am able to replicate a single table object as part of multimaster replication. I have 4 schemas to be replicated, and I found that Create_Master_Repobject procedure is used to register the objects to the group. Is this the only way to register the objects? this will be a tedious process as I have 4 shemas and under each schema there are around 80-90 objects. Is it possible to add replication support to schema-level directly to include all the objects so that as and whenever I create a new table in one schema it should be replicated on the schema of other master site. I would even want to know whether entire database replication is possible. Thanks in advance.
|
|
|
|
| Re: schema-level replication [message #75411 is a reply to message #75404] |
Fri, 14 November 2003 13:33  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
Oracle Streams can configure replication support on
GLOBAL(database), SCHEMA or TABLE level.
Nevertheless, Advanced Replication can only be configured
on TABLE level.
Best would be to write a PL/SQL block to loop though the
tables to configure replication support.
Best regards.
Frank Naude
|
|
|
|
| Re: schema-level replication [message #75412 is a reply to message #75411] |
Sun, 16 November 2003 21:35 |
Sushma MV
Messages: 4
Registered: November 2003
|
Junior Member |
|
|
hi,
Thanks Frank. I have already implemented the object-level replication using pl/sql looping construct. If I want the schema-level replication to be implemented how do I set it using Oracle 8i Advanced replication? Is there any built-in procedure that I can execute to do so? Thanks in advance.
Sushma.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
