1. 用shareplex用户连接数据库系统
2. 在表(shareplex_partition)中插入数据
INSERT INTO shareplex_partition
(partition_scheme, DESCRIPTION, target_table_owner, target_table_name, route, priority, ordering, options, col_conditions)
VALUES
(v_partition_scheme, v_description, v_target_table_owner, v_target_table_name, v_route, v_priority, v_ordering, v_options, v_col_conditions);
insert into SHAREPLEX_PARTITION values('xxxx_SCHEME','replication condition','xxx','',xxxx@o.xxxx','','','','((account_type = 1) or (account_type = 2))');
3. re-activate shareplex configruation file.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/223555/viewspace-506289/ ,如需转载,请注明出处,否则将追究法律责任。