标题: ORA-26879: "SET_ENQUEUE_DESTINATION" directive is not permitted [打印本页] 作者: admin 时间: 2016-9-2 10:17 标题: ORA-26879: "SET_ENQUEUE_DESTINATION" directive is not permitted ORA-26879: "SET_ENQUEUE_DESTINATION" directive is notpermitted on rules used by XStream outbound server "string" Cause: One or more rules,used by the specified XStream outbound server, had
SET_ENQUEUE_DESTINATION directive defined. Action: Execute thefollowing: 1) Execute query SELECT xr.rule_owner, xr.rule_
name, xr.rule_set_owner, xr.rule_set_name FROM dba_apply_enqueue e, dba_
xstream_rules xr WHERE e.rule_owner = xr.rule_owner AND e.rule_name =
xr.rule_name AND xr.streams_name = <specified outbound server>; 2) Foreach
rule returned, execute DBMS_APPLY_ADM.SET_ENQUEUE_DESTINATION
procedure to set the destination queue to null, or execute DBMS_RULE_
ADM.REMOVE_RULE to remove that rule from its associated rule set.