-
Help in config. of Site priority conflict resolution method
Hi,
I am testing Materialized View Replication (one master site and one MV site) .To resolve
conflict I employ Site Priority Conflict Resolution Method but I am not able to insert or update the records. I am getting transaction error while I insert or update the records.
This is my conflict resolution script i used Please help me out.
CONNECT repuser/rep@orcl.world
BEGIN DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (gname => 'rep_repg');END;/
BEGIN
DBMS_REPCAT.ALTER_MASTER_REPOBJECT (sname => 'repuser',
oname => 'Name',type => 'TABLE',ddl_text => 'ALTER TABLE repuser.Name ADD (site VARCHAR2(20))');END;/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname => 'repuser',oname => 'name',type => 'TABLE',
min_communication => TRUE);END;/
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT (gname => 'rep_repg',
type => 'TRIGGER',oname => 'insert_site',sname => 'repuser',ddl_text => 'CREATE TRIGGER repuser.insert_site
BEFORE UPDATE ON repuser.name FOR EACH ROW
BEGIN
IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN
SELECT global_name INTO :NEW.SITE FROM GLOBAL_NAME;
END IF;END;');END;/
BEGIN
DBMS_REPCAT.MAKE_COLUMN_GROUP (sname => 'repuser',
oname => 'Name',column_group => 'name_sitepriority_cg',
list_of_column_names => 'S_NO,FIRSTNAME,LASTNAME,site');
END;/
BEGIN
DBMS_REPCAT.DEFINE_SITE_PRIORITY (gname => 'rep_repg',
name => 'name_sitepriority_pg');END;/
BEGIN
DBMS_REPCAT.ADD_SITE_PRIORITY_SITE (gname => 'rep_repg',
name => 'name_sitepriority_pg',site => 'orcl.world',
priority => 100);END;/
BEGIN
DBMS_REPCAT.ADD_SITE_PRIORITY_SITE (gname => 'rep_repg',
name => 'name_sitepriority_pg',site => 'mvsite1.world',
priority => 50);END;/
BEGIN
DBMS_REPCAT.ADD_UPDATE_RESOLUTION (sname => 'repuser',
oname => 'Name',column_group => 'name_sitepriority_cg',
sequence_no => 1,method => 'SITE PRIORITY',
parameter_column_name => 'site',
priority_group => 'name_sitepriority_pg');END;/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname => 'repuser',oname => 'Name',type => 'TABLE', min_communication => TRUE);END;/
BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY (
gname => 'rep_repg');END;/
Last edited by arthik_babu; 02-04-2008 at 08:01 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|