Hi
I am working on Oracle database 10g. I am trying to implement advanced replication on my database.
Till now I have replicated tables and those are working fine. Now I want to replicate procedure, in this case on running all the procedures(adding packages and generating replication support) I am not getting any error. But after this I am not able to resume replication. In DBA_REPGROUP status of master group is QUIESCED.
I want to know why I am getting this problem and how can i solve it.
I am running following code for this :
BEGIN
DBMS_REPCAT.create_master_repobject (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE',
use_existing_object => TRUE,
COMMENT => 'Added on ' || SYSDATE,
retry => FALSE,
gname => 'MYREPGRP'
);
DBMS_REPCAT.create_master_repobject (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE BODY',
use_existing_object => TRUE,
COMMENT => 'Added on ' || SYSDATE,
retry => FALSE,
gname => 'MYREPGRP'
);
END;
BEGIN
DBMS_REPCAT.generate_replication_support (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE',
DISTRIBUTED => TRUE,
min_communication => TRUE
);
DBMS_REPCAT.generate_replication_support (sname => 'REPADMIN',
oname => 'PKG_COMMON_ERROR',
TYPE => 'PACKAGE BODY',
DISTRIBUTED => TRUE,
min_communication => TRUE
);
END;
Thanks,
Tanu