queue_name=>'strmadmin.SOURCE_QUEUE',
include_dml=>true,
include_ddl=>true,
source_database=>'CBOMS',
inclusion_rule=>false);
END;
/
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES (
table_name =>'bhomswas.DBMS_COMPRESSION',
streams_type=>'capture',
streams_name=>'capture_stream',
queue_name=>'strmadmin.SOURCE_QUEUE',
include_dml=>true,
include_ddl=>true,
source_database=>'CBOMS',
inclusion_rule=>false);
END;
/
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES (
table_name =>'bhomswas.DBMS_TABCOMP_TEMP_CMP',
streams_type=>'capture',
streams_name=>'capture_stream',
queue_name=>'strmadmin.SOURCE_QUEUE',
include_dml=>true,
include_ddl=>true,
source_database=>'CBOMS',
inclusion_rule=>false);
END;
/
PL/SQL procedure successfully completed.
3、启动caputer进程
SQL> begin
dbms_capture_adm.start_capture(
capture_name => 'capture_stream');
end;
/
PL/SQL procedure successfully completed.
解决上面问题