Oracle中利用EXP/IMP工具实现数据迁移(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;