CREATE SNAPSHOT LOG
ON "HOLEN"."REGISTER"
TABLESPACE "SYSTEM"
WITH PRIMARY KEY
EXCLUDING NEW VALUES;
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
sname => '"HOLEN"',
oname => '"REGISTER"',
type => 'TABLE',
min_communication => TRUE,
generate_80_compatible => FALSE);
END;
/
--MASTER端配置完毕
第三步:配置外网,即SNAPSHOT端
--外网作为SNAPSHOT
--创建外网用户HOLEN
CONN SYSTEM/PASSWORD@ORAWAI
--创建普通用户
CREATE USER "HOLEN" PROFILE "DEFAULT" IDENTIFIED BY "HOLEN";
GRANT "CONNECT" TO "HOLEN";
GRANT "DBA" TO "HOLEN";
GRANT "RESOURCE" TO "HOLEN";
--创建repadmin用户管理快照端复制环境
CREATE USER REPADMIN IDENTIFIED BY REPADMIN;
ALTER USER REPADMIN DEFAULT TABLESPACE USERS;
ALTER USER REPADMIN TEMPORARY TABLESPACE TEMP;
GRANT connect, resource TO REPADMIN;
CREATE USER "HOLEN" PROFILE "DEFAULT" IDENTIFIED BY "HOLEN" ;
GRANT "CONNECT" TO "HOLEN";
GRANT "DBA" TO "HOLEN";
GRANT "RESOURCE" TO "HOLEN";
--导入内网数据库备份,在dos下到入完成(表LAWTABLE,REGISTER及其他表)
第二步:配置内网,即MASTER端(续)
--需要复制(同步)的表为HOLEN用户下的LAWTABLE,REGISTER
--创建repadmin用户管理复制环境
CREATE USER REPADMIN IDENTIFIED BY REPADMIN;
ALTER USER REPADMIN DEFAULT TABLESPACE USERS;
ALTER USER REPADMIN TEMPORARY TABLESPACE TEMP;
GRANT connect, resource TO REPADMIN;