配置oracle stream(step by step setup schema level Streams Replication)
过程和database level基本一样，本篇只简单介绍下过程
说明：
source 为hrdbprim，target db为hrdb，此处的数据库名称必须和global_name一致hrdbprim =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.124.239)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hrdbprim)
)
)
hrdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.124.233)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hrdb)
)
)
STRMADMIN = stream管理用户
WJ = 需要复制同步的用户
一、环境准备
1,删除原有的stream配置
execute DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
2，配置数据库参数，一般需要设置global_names, _job_queue_interval, sga_target, streams_pool_size四个参数
3，创建管理用户STRMADMIN