Home » Server Options » Replication » replication support generation status
replication support generation status [message #75413] Mon, 17 November 2003 02:43
Sushma MV
Messages: 4
Registered: November 2003
Junior Member
I have four schemas to be replicated, I'm using multimaster replication. To provide the support, I have included all the schema-objects using pl/sql looping structure. When I execute the procedures and check the status in DBA Studio, it says 'Doing Generation' for all objects and this is going on for 2+hrs. There are no errors reported. Totally there are 90 tables.
I would like to know whether support for generation takes so much time or is there any other problem?
The statements go like this:
declare cursor all_object
is select * from all_objects where object_type='table' and owner='dbowner';
For cur in all_object loop
End loop;

How else can I optimise this? How can I check the generation status using procedures? Thanks in advance.
Previous Topic: schema-level replication
Next Topic: Asynchronous Mulimaster Replication in Red Hat Linux
Goto Forum:

Current Time: Sat May 18 05:26:16 CDT 2024