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.
|
|
|