Oracle中利用EXP/IMP工具实现数据迁移(1)(3)

　SQL> CONNECT REPADMIN/REPADMIN@RAC1已连接。
　SQL> BEGIN
　2 DBMS_REPCAT.CREATE_MASTER_REPGROUP(GNAME => 'REP_GROUP');
　3 END;
　4 / 

　SQL> BEGIN
　2 DBMS_REPCAT.CREATE_MASTER_REPOBJECT
(GNAME => 'REP_GROUP', TYPE => 'TABLE',
　3 ONAME => 'T', SNAME => 'YANGTK', USE_EXISTING_OBJECT =>
TRUE, COPY_ROWS => FALSE);
　4 END;
　5 / 

　SQL> BEGIN
　2 DBMS_REPCAT.CREATE_MASTER_REPOBJECT
(GNAME => 'REP_GROUP', TYPE => 'TABLE',
　3 ONAME => 'T1', SNAME => 'YANGTK', USE_EXISTING_OBJECT => 
TRUE, COPY_ROWS => FALSE);
　4 END;
5 / 

　SQL> BEGIN
　2 DBMS_REPCAT.CREATE_MASTER_REPOBJECT(GNAME => 
'REP_GROUP', TYPE => 'INDEX',
　3 ONAME => 'IND_T1_FID', SNAME => 'YANGTK',
USE_EXISTING_OBJECT => FALSE, COPY_ROWS => FALSE);
　4 END;
　5 / 

　SQL> BEGIN
　2 DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(SNAME => 'YANGTK',
　3 ONAME => 'T', TYPE => 'TABLE', MIN_COMMUNICATION => TRUE);
　4 END;
　5 / 

SQL> BEGIN
2 DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(SNAME => 'YANGTK',
3 ONAME => 'T1', TYPE => 'TABLE', MIN_COMMUNICATION => TRUE);
4 END;
5 / 

　SQL> BEGIN
　2 DBMS_REPCAT.RESUME_MASTER_ACTIVITY(GNAME => 'REP_GROUP');
　3 END;
　4 / 

　SQL> COMMIT;

　SQL> CONNECT SYSTEM/TEST@TESTMV已连接。
　SQL> CREATE USER MVADMIN IDENTIFIED BY MVADMIN DEFAULT TABLESPACE NDMAIN;

　SQL> BEGIN
　2 DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA(USERNAME => 'MVADMIN');
　3 END;
　4 / 

　SQL> GRANT COMMENT ANY TABLE TO MVADMIN;

　SQL> GRANT LOCK ANY TABLE TO MVADMIN;

　SQL> BEGIN
　2 DBMS_DEFER_SYS.REGISTER_PROPAGATOR(USERNAME => 'MVADMIN');
　3 END;
　4 / 

　SQL> GRANT SELECT ANY DICTIONARY TO MVADMIN;

　SQL> CREATE PUBLIC DATABASE LINK RAC1.US.ORACLE.COM USING 'RAC1';

　SQL> CONNECT MVADMIN/MVADMIN@TESTMV已连接。
　SQL> CREATE DATABASE LINK RAC1.US.ORACLE.COM 
CONNECT TO REPADMIN IDENTIFIED BY REPADMIN;