Not able to create snapshot rep group at Snapshot site [message #195326] |
Thu, 28 September 2006 01:08 |
ask4shailesh
Messages: 4 Registered: September 2006 Location: mumbai
|
Junior Member |
|
|
Hi,
I am not able to create snapshot rep group, following is the code which I executed:
/*At Base table location*/
BEGIN
Dbms_Repcat.Create_Master_Repgroup('TEST_REPGRP');
END;
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT(sname => 'schema1',
oname => 'src_table',
type => 'TABLE',
gname => 'TEST_REPGRP');
END;
BEGIN
DBMS_DEFER_SYS.REGISTER_PROPAGATOR (
username => 'aidev');
END;
begin
dbms_repcat.generate_replication_support(
sname=>'schema1',
oname=>'src_table',
type=>'TABLE',
min_communication=>TRUE);
end;
begin
dbms_repcat.resume_master_activity(
gname=>'TEST_REPGRP');
end;
/*At Snapshot location*/
CREATE PUBLIC DATABASE TEST_DB_LINK
CONNECT TO shailesh
IDENTIFIED BY *****
USING 'abc.xyz.com';
BEGIN
DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP (
username => 'shailesh',
privilege_type => 'receiver',
list_of_gnames => NULL);
END;
GLOBAL_NAMES at master table site and snapshot site is set as FALSE;
However, following block is giving error ---
BEGIN
DBMS_REPCAT.create_snapshot_repgroup(
gname => 'TEST_REPGRP',
master => 'abc.xyz.com',
propagation_mode => 'ASYNCHRONOUS');
END;
error = ORA 23313: Object group public.TEST_REPGRP is not mastered at abc.xyz.com.
Please suggest.
Thnaks,
Shailesh
|
|
|