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
dbms_repcat.create_master_repobject(cur.owner,cur.object_name,cur.object_type,'repgrp');
dbms_repcat.generate_replication_support(cur.owner,cur.object_name,cur.object_type);
End loop;
dbms_repcat.resume_master_activity('repgrp');

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


Current Time: Thu Mar 28 04:54:36 CDT 2024