我在oracle10 上创建了一个传播规则,现在我要删除重建,如何删除?
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name => 'scott.emp',
streams_name => 'sour_to_targ',
source_queue_name => 'stradmin.streams_queue',
destination_queue_name =>'[email protected]',
include_dml => true,
include_ddl => true,
source_database => 'red9.cn',
queue_to_queue=>true,
inclusion_rule=>true);
END;现在我要删除重建,怎么删除?
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name => 'scott.emp',
streams_name => 'sour_to_targ',
source_queue_name => 'stradmin.streams_queue',
destination_queue_name =>'[email protected]',
include_dml => true,
include_ddl => true,
source_database => 'red9.cn',
queue_to_queue=>true,
inclusion_rule=>true);
END;现在我要删除重建,怎么删除?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货