Home » Server Options » Replication » Not able to create snapshot rep group at Snapshot site
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
Previous Topic: Materialized View Log
Next Topic: replicating only in one direction???
Goto Forum:
  


Current Time: Thu Mar 28 13:40:01 CDT 2024