Oracle CDC基本操作及用法

1、创建change_set

BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET( 
change_set_name => 'CHANGE_SET_USER1', 
description => 'Change set for USER1', 
change_source_name => 'SYNC_SOURCE'

); 

END;

2、创建change_table

BEGIN

DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE( 
owner => 'system', 
change_table_name => 'CT_f_u_info', 
change_set_name => 'CHANGE_SET_f_u_info', 
source_schema => 'system', 
source_table => 'f_u_info', 
column_type_list => 'NAME VARCHAR2(100),ID NUMBER,ADDRESS VARCHAR2(100),SEX VARCHAR2(100),DEGREE VARCHAR2(100),FLAG VARCHAR2(1)', 
capture_values => 'both', 
rs_id