ORA-26880: "SET_EXECUTE" directive is not permitted on rules used by XStream outbound server "string"

ORA-26880: "SET_EXECUTE" directive is not permitted on rules used by XStream outbound server "string"
Cause: One or more rules, used by the specified XStream outbound server, had SET_EXECUTE directive defined.
Action: Execute the following: 1) Execute query SELECT xr.rule_owner, xr.rule_name, xr.rule_set_owner, xr.rule_set_name FROM dba_apply_execute e, dba_xstream_rules xr WHERE e.rule_owner = xr.rule_owner AND e.rule_name = xr.rule_name AND xr.streams_name = ; 2) For each rule returned, use DBMS_APPLY_ADM.SET_EXECUTE procedure to set the EXECUTE parameter to TRUE, or use DBMS_RULE_ADM.REMOVE_RULE to remove that rule from its associated rule set.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:47

ORA-26880：“SET_EXECUTE”指令不允许XStream出站服务器使用的规则“ string ”,
.原因：由指定的XStream出站服务器使用的一个或多个规则已定义了SET_EXECUTE指令。,
.操作：执行以下操作：1）执行查询SELECT xr.rule_owner，xr.rule_name，xr.rule_set_owner，xr.rule_set_name FROM dba_apply_execute e，dba_xstream_rules xr WHERE e.rule_owner = xr.rule_owner AND e.rule_name = xr.rule_name AND xr .streams_name = <指定的出站服务器>; 2）对于返回的每个规则，使用DBMS_APPLY_ADM.SET_EXECUTE过程将EXECUTE参数设置为TRUE，或使用DBMS_RULE_ADM.REMOVE_RULE从其关联的规则集中删除该规则。,
.

aiaiDBA

13718043309

010-86462881

ORA-26880: "SET_EXECUTE" directive is not permitted on rules used by XStream outbound server "string"

1 个回答

相似问题