oracle cdc机制异步模式hotlog学习笔记

大致流程：

系统用户配置：创建用户、给予相应权限、设置数据库模式

发布者配置：准备改变表、创建改变集、创建改变表、激活改变集、将改变表授权给订阅者

订阅者配置：创建订阅集、创建订阅表、激活订阅表、更新或情况扩展窗口、查询扩展窗口上的数据（可查询增量数据）

sys用户操作：
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
archive log list;
是归档模式后就行了


GRANT CREATE TABLE TO scott;
GRANT CREATE TABLESPACE TO scott;
GRANT UNLIMITED TABLESPACE TO scott;
GRANT SELECT_CATALOG_ROLE TO scott;
GRANT EXECUTE_CATALOG_ROLE TO scott;
GRANT EXECUTE ON DBMS_CDC_PUBLISH TO scott;//system权限不足，需要sys
GRANT CREATE SESSION TO scott;
GRANT CREATE SEQUENCE TO scott;
GRANT DBA TO scott;


//流程中可能执行多次的
create table dog(
id number,
name varchar2(20)
);
//为了方便创建一个同样结构的表
create table cat(
id number,
name varchar2(20)
);


insert into dog values(1,'xx');
insert into dog values(2,'hh');
select * from dog;


insert into cat values(1,'xx');
insert into cat values(2,'hh');
select * from cat;


create user sub identified by sub;
grant create session to sub;


//流程中可能执行多次的
grant all on dog to /发布者/;
grant all on dog to sub;


grant all on cat to /发布者/;