1 目标库配置

1.1 创建用户及赋权

• 创建用户

     create user zcbus identified by zcbus;

• 用户赋权

     GRANT CONNECT to zcbus;
     GRANT RESOURCE to zcbus;
     GRANT CREATE SESSION TO zcbus;
     GRANT CREATE ANY TABLE TO zcbus;
     GRANT CREATE ANY INDEX TO zcbus;
     GRANT SELECT ANY TABLE TO zcbus;
     GRANT SELECT ON dba_tab_columns to zcbus;
     GRANT SELECT ON dba_constraints to zcbus;
     GRANT SELECT ON dba_indexes to zcbus;
     GRANT SELECT ON dba_tab_cols to zcbus;
     GRANT SELECT ON dba_cons_columns to zcbus;
     GRANT SELECT ON dba_ind_columns to zcbus;
     GRANT ALTER SESSION TO zcbus;
     GRANT ALTER ANY TABLE TO zcbus;
     GRANT ALTER ANY INDEX TO zcbus;
     GRANT DROP ANY TABLE TO zcbus;
     GRANT DROP ANY INDEX TO zcbus;
     GRANT INSERT ANY TABLE TO zcbus;
     GRANT UPDATE ANY TABLE TO zcbus;
     GRANT DELETE ANY TABLE TO zcbus;
     GRANT COMMENT ANY TABLE TO zcbus;

• 或赋给用户DBA权限

    GRANT dba TO zcbus;

2 补充说明

2.1 配置目标数据库参数列表