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

　SQL> CONN SYSTEM/TEST@RAC1已连接。
　SQL> CREATE USER REPADMIN IDENTIFIED BY REPADMIN DEFAULT TABLESPACE NDMAIN;

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

　SQL> GRANT COMMENT ANY TABLE TO REPADMIN;

　SQL> GRANT LOCK ANY TABLE TO REPADMIN;

　SQL> GRANT SELECT ANY DICTIONARY TO REPADMIN;

　SQL> GRANT SELECT_CATALOG_ROLE TO REPADMIN;

　SQL> GRANT CREATE SESSION TO REPADMIN;

　SQL> GRANT SELECT ANY TABLE TO REPADMIN;

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

　SQL> BEGIN
　2 DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP(USERNAME => 'REPADMIN',
　3 PRIVILEGE_TYPE => 'RECEIVER', LIST_OF_GNAMES => NULL);
　4 END;
　5 / 

　SQL> BEGIN
　2 DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP(USERNAME => 'REPADMIN',
　3 PRIVILEGE_TYPE => 'PROXY_SNAPADMIN',
　4 LIST_OF_GNAMES => NULL);
　5 END;
　6 / 

　SQL> CONN REPADMIN/REPADMIN@RAC1已连接。
　SQL> BEGIN
　2 DBMS_DEFER_SYS.SCHEDULE_PURGE(NEXT_DATE => SYSDATE,
INTERVAL => 'SYSDATE + 1/24', DELAY_SECONDS
　=> 0);
　3 END;
　4 /