oracle包抽取cdc数据

---<MUTIBARCODE>
---============================================

begin
dbms_cdc_publish.create_change_table (
owner => 'odiwork',
change_table_name => 'cdc__MUTIBARCODE',
change_set_name => 'SYNC_SET',
source_schema => 'odiwork',
source_table => 'MUTIBARCODE',
column_type_list =>'
BZDM VARCHAR2(16),
BARCODE VARCHAR2(20),
SERIALNO NUMBER(20),
XTSJ  DATE
',
capture_values => 'both',
rs_id => 'y',
row_id => 'y',
user_id => 'y',
timestamp => 'y',
object_id => 'n',
source_colmap => 'y',
target_colmap => 'y',
options_string => null);
end;

---删除表
begin
dbms_cdc_publish.drop_change_table(
'odiwork',
'cdc__BRAND',
'Y');
end