CDC 同步方式
/**********************************************/
--同步 CDC 发布步骤
/***********************************************/
--修改数据库 java_pool_size
alter system set java_pool_size=50000000 scope=spfile;
--2 创建发布者并授权
CREATE USER cdcpub IDENTIFIED BY cdcpub DEFAULT TABLESPACE ts_cdcpub QUOTA
UNLIMITED ON SYSTEM QUOTA UNLIMITED ON SYSAUX;
GRANT CREATE SESSION TO cdcpub;
GRANT CREATE TABLE TO cdcpub;
GRANT CREATE TABLESPACE TO cdcpub;
GRANT UNLIMITED TABLESPACE TO cdcpub;
GRANT SELECT_CATALOG_ROLE TO cdcpub;
GRANT EXECUTE_CATALOG_ROLE TO cdcpub;
GRANT CONNECT, RESOURCE TO cdcpub;
--3 创建变更集
BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
change_set_name => 'USERACCOUNT_DAILY',
description => 'Change set for useraccount info',
change_source_name => 'SYNC_SOURCE');
END;
/
--3 创建变更表
BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE(
owner => 'cdcpub',
change_table_name => 'useraccount_ct',
change_set_name => 'USERACCOUNT_DAILY',
source_schema => 'cdcpub',
source_table => 'USERACCOUNT',
column_type_list => 'USERID VARCHAR2(20),USERNAME VARCHAR2(30),
BIRTHDAY DATE',
capture_values => 'both',
rs_id => 'y',
row_id => 'n',
user_id => 'n',
评论2