diff --git a/trans-datax-job/datax/job/1001.job_TMP_DM_GENDER.json b/trans-datax-job/datax/job/1001.job_TMP_DM_GENDER.json
new file mode 100644
index 0000000..a9c3705
--- /dev/null
+++ b/trans-datax-job/datax/job/1001.job_TMP_DM_GENDER.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+select
+  DM, MC
+from UIDS_DM_GENDER
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "DM",
+                            "MC"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_DM_GENDER"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_DM_GENDER"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/1002.job_TMP_DM_ORGTYPE.json b/trans-datax-job/datax/job/1002.job_TMP_DM_ORGTYPE.json
new file mode 100644
index 0000000..1b45b2c
--- /dev/null
+++ b/trans-datax-job/datax/job/1002.job_TMP_DM_ORGTYPE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+select
+  DM, MC
+from UIDS_DM_ORGTYPE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "DM",
+                            "MC"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_DM_ORGTYPE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_DM_ORGTYPE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/1003.job_TMP_DM_ACCOUNTTYPE.json b/trans-datax-job/datax/job/1003.job_TMP_DM_ACCOUNTTYPE.json
new file mode 100644
index 0000000..eee499e
--- /dev/null
+++ b/trans-datax-job/datax/job/1003.job_TMP_DM_ACCOUNTTYPE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+select
+  DM, MC
+from UIDS_DM_ACCOUNTTYPE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "DM",
+                            "MC"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_DM_ACCOUNTTYPE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_DM_ACCOUNTTYPE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/1004.job_TMP_DM_IDENTITYTYPE.json b/trans-datax-job/datax/job/1004.job_TMP_DM_IDENTITYTYPE.json
new file mode 100644
index 0000000..ca35cda
--- /dev/null
+++ b/trans-datax-job/datax/job/1004.job_TMP_DM_IDENTITYTYPE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+select
+  DM, MC
+from UIDS_DM_IDENTITYTYPE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "DM",
+                            "MC"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_DM_IDENTITYTYPE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_DM_IDENTITYTYPE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/2001.job_TMP_ORGANIZE.json b/trans-datax-job/datax/job/2001.job_TMP_ORGANIZE.json
new file mode 100644
index 0000000..4678389
--- /dev/null
+++ b/trans-datax-job/datax/job/2001.job_TMP_ORGANIZE.json
@@ -0,0 +1,68 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+select
+  ID, PID, CODE, NAME
+from T_ORGANIZE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ID",
+                            "PID",
+                            "CODE",
+                            "NAME"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_ORGANIZE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_ORGANIZE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/2002.job_TMP_PERSON.json b/trans-datax-job/datax/job/2002.job_TMP_PERSON.json
new file mode 100644
index 0000000..ab317aa
--- /dev/null
+++ b/trans-datax-job/datax/job/2002.job_TMP_PERSON.json
@@ -0,0 +1,80 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+select
+  ID, NAME, NICK, EMAIL, TEL, MOBILE, ID_CARD, REMARK, USERTYPEID, DICORGID, STAFFNO, STUDENTNO, IS_TEACHER, IS_NONGRADUATE, IS_GRADUATE, IS_PH_D_CANDIDATE
+from T_PERSON
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ID",
+                            "NAME",
+                            "NICK",
+                            "EMAIL",
+                            "TEL",
+                            "MOBILE",
+                            "ID_CARD",
+                            "REMARK",
+                            "USERTYPEID",
+                            "DICORGID",
+                            "STAFFNO",
+                            "STUDENTNO",
+                            "IS_TEACHER",
+                            "IS_NONGRADUATE",
+                            "IS_GRADUATE",
+                            "IS_PH_D_CANDIDATE"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_PERSON"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_PERSON"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/2003.job_TMP_ACCOUNT.json b/trans-datax-job/datax/job/2003.job_TMP_ACCOUNT.json
new file mode 100644
index 0000000..6b9388e
--- /dev/null
+++ b/trans-datax-job/datax/job/2003.job_TMP_ACCOUNT.json
@@ -0,0 +1,118 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT PASSWORD_POLICY_ID,
+    ID,
+    ACCOUNT_NAME,
+    PASSWORD,
+    ENCODED_PASSWORD,
+    IS_LOCKED,
+    IS_EXIPRED,
+    IS_ENABLED,
+    IS_PASSWORD_EXIPRED,
+    PERSON_ID,
+    CREATE_TIME,
+    LAST_LOGOUT_TIME,
+    LOGIN_IP,
+    LOGIN_TIME,
+    CREATE_ID,
+    IS_FIRST_CHANGE_PASS,
+    EXPIRED_DATE,
+    LAST_LOGIN_IP,
+    LAST_LOGIN_TIME,
+    LAST_UPDATE_TIME,
+    CREATE_ACCOUNT,
+    LAST_UPDATE_ACCOUNT,
+    CHECKSTATUES,
+    LOST_PASSWORD_POLICY_ID,
+    ACCOUNTTYPE_DM,
+    IS_ACTIVATED,
+    IS_DELETED,
+    IS_BLACKLISTED
+FROM T_ACCOUNT
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "PASSWORD_POLICY_ID",
+                            "ID",
+                            "ACCOUNT_NAME",
+                            "PASSWORD",
+                            "ENCODED_PASSWORD",
+                            "IS_LOCKED",
+                            "IS_EXIPRED",
+                            "IS_ENABLED",
+                            "IS_PASSWORD_EXIPRED",
+                            "PERSON_ID",
+                            "CREATE_TIME",
+                            "LAST_LOGOUT_TIME",
+                            "LOGIN_IP",
+                            "LOGIN_TIME",
+                            "CREATE_ID",
+                            "IS_FIRST_CHANGE_PASS",
+                            "EXPIRED_DATE",
+                            "LAST_LOGIN_IP",
+                            "LAST_LOGIN_TIME",
+                            "LAST_UPDATE_TIME",
+                            "CREATE_ACCOUNT",
+                            "LAST_UPDATE_ACCOUNT",
+                            "CHECKSTATUES",
+                            "LOST_PASSWORD_POLICY_ID",
+                            "ACCOUNTTYPE_DM",
+                            "IS_ACTIVATED",
+                            "IS_DELETED",
+                            "IS_BLACKLISTED"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_ACCOUNT"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_ACCOUNT"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/2004.job_TMP_REGISTERED_SERVICE.json b/trans-datax-job/datax/job/2004.job_TMP_REGISTERED_SERVICE.json
new file mode 100644
index 0000000..6cf54e8
--- /dev/null
+++ b/trans-datax-job/datax/job/2004.job_TMP_REGISTERED_SERVICE.json
@@ -0,0 +1,116 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ID,
+    NAME,
+    SERVICE_PATTERN,
+    IS_USER_MAP,
+    IS_USER_MAP_PASS,
+    IS_EXTRA_LOGIN_PARAM,
+    IS_SSO_ENABLED,
+    IS_ENABLED,
+    IS_PROXY_ENABLED,
+    IS_ANOY,
+    ORDER_NUM,
+    IS_ATTRIBUTE_ENABLED,
+    AUTH_TYPE,
+    LOGIN_ADDRESS,
+    LOGOUT_ADDRESS,
+    IS_DEFAULT_LOGIN_SCREEN,
+    CODE,
+    CREATERUSER,
+    CREATETIME,
+    UPDATETIME,
+    VALIDATE_ADDRESS,
+    SEND_TYPE,
+    SIMULATIONTYPE,
+    IS_DELETED,
+    CLIENT_ID,
+    CLIENT_SECRET,
+    REDIRECT_URI
+FROM T_REGISTERED_SERVICE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ID",
+                            "NAME",
+                            "SERVICE_PATTERN",
+                            "IS_USER_MAP",
+                            "IS_USER_MAP_PASS",
+                            "IS_EXTRA_LOGIN_PARAM",
+                            "IS_SSO_ENABLED",
+                            "IS_ENABLED",
+                            "IS_PROXY_ENABLED",
+                            "IS_ANOY",
+                            "ORDER_NUM",
+                            "IS_ATTRIBUTE_ENABLED",
+                            "AUTH_TYPE",
+                            "LOGIN_ADDRESS",
+                            "LOGOUT_ADDRESS",
+                            "IS_DEFAULT_LOGIN_SCREEN",
+                            "CODE",
+                            "CREATERUSER",
+                            "CREATETIME",
+                            "UPDATETIME",
+                            "VALIDATE_ADDRESS",
+                            "SEND_TYPE",
+                            "SIMULATIONTYPE",
+                            "IS_DELETED",
+                            "CLIENT_ID",
+                            "CLIENT_SECRET",
+                            "REDIRECT_URI"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REGISTERED_SERVICE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REGISTERED_SERVICE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/2005.job_TMP_WEAK_PASSWORD_DICT.json b/trans-datax-job/datax/job/2005.job_TMP_WEAK_PASSWORD_DICT.json
new file mode 100644
index 0000000..1632cc7
--- /dev/null
+++ b/trans-datax-job/datax/job/2005.job_TMP_WEAK_PASSWORD_DICT.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ID,
+    VALUE
+FROM T_WEAK_PASSWORD_DICT
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ID",
+                            "VALUE"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_WEAK_PASSWORD_DICT"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_WEAK_PASSWORD_DICT"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/2006.job_TMP_ACCOUNT_QQ.json b/trans-datax-job/datax/job/2006.job_TMP_ACCOUNT_QQ.json
new file mode 100644
index 0000000..d18d9e3
--- /dev/null
+++ b/trans-datax-job/datax/job/2006.job_TMP_ACCOUNT_QQ.json
@@ -0,0 +1,82 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ID,
+    ACCOUNT_NAME,
+    QQ_OPENID,
+    QQ_ACCESS_TOKEN,
+    ACCESS_TOKEN_TIME,
+    EXPIRES_IN,
+    QQ_REFRESH_TOKEN,
+    QQ_NICKNAME,
+    IS_BINDED,
+    OPTLOCK
+FROM T_ACCOUNT_QQ
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ID",
+                            "ACCOUNT_NAME",
+                            "QQ_OPENID",
+                            "QQ_ACCESS_TOKEN",
+                            "ACCESS_TOKEN_TIME",
+                            "EXPIRES_IN",
+                            "QQ_REFRESH_TOKEN",
+                            "QQ_NICKNAME",
+                            "IS_BINDED",
+                            "OPTLOCK"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_ACCOUNT_QQ"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_ACCOUNT_QQ"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/2007.job_TMP_ACCOUNT_WECHAT.json b/trans-datax-job/datax/job/2007.job_TMP_ACCOUNT_WECHAT.json
new file mode 100644
index 0000000..5a5a268
--- /dev/null
+++ b/trans-datax-job/datax/job/2007.job_TMP_ACCOUNT_WECHAT.json
@@ -0,0 +1,86 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ID,
+    ACCOUNT_NAME,
+    WECHAT_OPENID,
+    WECHAT_UNIONID,
+    WECHAT_ACCESS_TOKEN,
+    ACCESS_TOKEN_TIME,
+    EXPIRES_IN,
+    WECHAT_REFRESH_TOKEN,
+    REFRESH_TOKEN_TIME,
+    WECHAT_NICKNAME,
+    IS_BINDED,
+    OPTLOCK
+FROM T_ACCOUNT_WECHAT
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ID",
+                            "ACCOUNT_NAME",
+                            "WECHAT_OPENID",
+                            "WECHAT_UNIONID",
+                            "WECHAT_ACCESS_TOKEN",
+                            "ACCESS_TOKEN_TIME",
+                            "EXPIRES_IN",
+                            "WECHAT_REFRESH_TOKEN",
+                            "REFRESH_TOKEN_TIME",
+                            "WECHAT_NICKNAME",
+                            "IS_BINDED",
+                            "OPTLOCK"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_ACCOUNT_WECHAT"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_ACCOUNT_WECHAT"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3001.job_TMP_TB_ORGANIZE.json b/trans-datax-job/datax/job/3001.job_TMP_TB_ORGANIZE.json
new file mode 100644
index 0000000..e2f75d9
--- /dev/null
+++ b/trans-datax-job/datax/job/3001.job_TMP_TB_ORGANIZE.json
@@ -0,0 +1,112 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ORGID,
+    ORGPARENTID,
+    ORGPATHID,
+    ORGCODE,
+    ORGNAME,
+    ORGTYPE,
+    ORGSTATUS,
+    ORGMEMO,
+    ORGCREATEUSER,
+    ORGCREATETIME,
+    ORGUPDATETIME,
+    ORGSHORTNAME,
+    ORGENNAME,
+    ORGSHORTENNAME,
+    ORGSHORTSPELLNAME,
+    ORGADDRESS,
+    ORGTYPECODE,
+    ORGEXPIREDATE,
+    ORGINESSE,
+    ORGESTABLISHYM,
+    ORGADMINUSERID,
+    ORGPARYTUSERID,
+    ORGISDELETED,
+    ORGDELETETIME,
+    ORGDELETEUSER
+FROM UIDS_TB_ORGANIZE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ORGID",
+                            "ORGPARENTID",
+                            "ORGPATHID",
+                            "ORGCODE",
+                            "ORGNAME",
+                            "ORGTYPE",
+                            "ORGSTATUS",
+                            "ORGMEMO",
+                            "ORGCREATEUSER",
+                            "ORGCREATETIME",
+                            "ORGUPDATETIME",
+                            "ORGSHORTNAME",
+                            "ORGENNAME",
+                            "ORGSHORTENNAME",
+                            "ORGSHORTSPELLNAME",
+                            "ORGADDRESS",
+                            "ORGTYPECODE",
+                            "ORGEXPIREDATE",
+                            "ORGINESSE",
+                            "ORGESTABLISHYM",
+                            "ORGADMINUSERID",
+                            "ORGPARYTUSERID",
+                            "ORGISDELETED",
+                            "ORGDELETETIME",
+                            "ORGDELETEUSER"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_ORGANIZE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_ORGANIZE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3002.job_TMP_TB_USER.json b/trans-datax-job/datax/job/3002.job_TMP_TB_USER.json
new file mode 100644
index 0000000..ec2c259
--- /dev/null
+++ b/trans-datax-job/datax/job/3002.job_TMP_TB_USER.json
@@ -0,0 +1,114 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT USERID,
+    USERORGID,
+    USERNAME,
+    USERNICK,
+    USERSTATUS,
+    USERMEMO,
+    USERCREATEUSER,
+    USERCREATETIME,
+    USERUPDATETIME,
+    USERSTAFFNO,
+    USERSTUDENTNO,
+    USERIDENTITYTYPE,
+    USERIDENTITYNO,
+    USERGENDER,
+    USERBIRTHDATE,
+    USERPHONE,
+    USERMOBILE,
+    USERMAIL,
+    USERSERIALNO,
+    USERPASSWORD,
+    USERISDELETED,
+    USERISACTIVATED,
+    USERISEXPIRED,
+    USERDELETEUSER,
+    USERDELETETIME,
+    USERISBLACKLISTED
+FROM UIDS_TB_USER
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "USERID",
+                            "USERORGID",
+                            "USERNAME",
+                            "USERNICK",
+                            "USERSTATUS",
+                            "USERMEMO",
+                            "USERCREATEUSER",
+                            "USERCREATETIME",
+                            "USERUPDATETIME",
+                            "USERSTAFFNO",
+                            "USERSTUDENTNO",
+                            "USERIDENTITYTYPE",
+                            "USERIDENTITYNO",
+                            "USERGENDER",
+                            "USERBIRTHDATE",
+                            "USERPHONE",
+                            "USERMOBILE",
+                            "USERMAIL",
+                            "USERSERIALNO",
+                            "USERPASSWORD",
+                            "USERISDELETED",
+                            "USERISACTIVATED",
+                            "USERISEXPIRED",
+                            "USERDELETEUSER",
+                            "USERDELETETIME",
+                            "USERISBLACKLISTED"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_USER"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_USER"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3003.job_TMP_TB_ACCOUNT.json b/trans-datax-job/datax/job/3003.job_TMP_TB_ACCOUNT.json
new file mode 100644
index 0000000..dc5e591
--- /dev/null
+++ b/trans-datax-job/datax/job/3003.job_TMP_TB_ACCOUNT.json
@@ -0,0 +1,112 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ACCOUNTID,
+    ACCOUNTUSERID,
+    ACCOUNTKEY,
+    ACCOUNTPWD,
+    ACCOUNTTYPE,
+    ACCOUNTSTATUS,
+    ACCOUNTCREATEUSER,
+    ACCOUNTCREATETIME,
+    ACCOUNTUPDATETIME,
+    ACCOUNTPWDSTRATEGYID,
+    ACCOUNTLOGINTIME,
+    ACCOUNTLOGINIP,
+    ACCOUNTLOGOUTTIME,
+    ACCOUNTFAILEDTIMES,
+    ACCOUNTKEYCREATETIME,
+    ACCOUNTKEYINVALIDTIME,
+    ACCOUNTPWDCHANGETIME,
+    ACCOUNTPWDINVALIDTIME,
+    ACCOUNTPWDSTRENGTH,
+    ACCOUNTISDELETED,
+    ACCOUNTDELETEUSER,
+    ACCOUNTDELETETIME,
+    ACCOUNTISACTIVATED,
+    ACCOUNTISEXPIRED,
+    ACCOUNTISBLACKLISTED
+FROM UIDS_TB_ACCOUNT
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ACCOUNTID",
+                            "ACCOUNTUSERID",
+                            "ACCOUNTKEY",
+                            "ACCOUNTPWD",
+                            "ACCOUNTTYPE",
+                            "ACCOUNTSTATUS",
+                            "ACCOUNTCREATEUSER",
+                            "ACCOUNTCREATETIME",
+                            "ACCOUNTUPDATETIME",
+                            "ACCOUNTPWDSTRATEGYID",
+                            "ACCOUNTLOGINTIME",
+                            "ACCOUNTLOGINIP",
+                            "ACCOUNTLOGOUTTIME",
+                            "ACCOUNTFAILEDTIMES",
+                            "ACCOUNTKEYCREATETIME",
+                            "ACCOUNTKEYINVALIDTIME",
+                            "ACCOUNTPWDCHANGETIME",
+                            "ACCOUNTPWDINVALIDTIME",
+                            "ACCOUNTPWDSTRENGTH",
+                            "ACCOUNTISDELETED",
+                            "ACCOUNTDELETEUSER",
+                            "ACCOUNTDELETETIME",
+                            "ACCOUNTISACTIVATED",
+                            "ACCOUNTISEXPIRED",
+                            "ACCOUNTISBLACKLISTED"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_ACCOUNT"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_ACCOUNT"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3004.job_TMP_TB_USERGROUP.json b/trans-datax-job/datax/job/3004.job_TMP_TB_USERGROUP.json
new file mode 100644
index 0000000..ffee491
--- /dev/null
+++ b/trans-datax-job/datax/job/3004.job_TMP_TB_USERGROUP.json
@@ -0,0 +1,84 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT USERGRPID,
+    USERGRPCODE,
+    USERGRPNAME,
+    USERGRPMEMO,
+    USERGRPSTATUS,
+    USERGRPCREATEUSER,
+    USERGRPCREATETIME,
+    USERGRPUPDATETIME,
+    USERGRPISDELETED,
+    USERGRPDELETETIME,
+    USERGRPDELETEUSER
+FROM UIDS_TB_USERGROUP
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "USERGRPID",
+                            "USERGRPCODE",
+                            "USERGRPNAME",
+                            "USERGRPMEMO",
+                            "USERGRPSTATUS",
+                            "USERGRPCREATEUSER",
+                            "USERGRPCREATETIME",
+                            "USERGRPUPDATETIME",
+                            "USERGRPISDELETED",
+                            "USERGRPDELETETIME",
+                            "USERGRPDELETEUSER"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_USERGROUP"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_USERGROUP"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3005.job_TMP_TB_ROLE.json b/trans-datax-job/datax/job/3005.job_TMP_TB_ROLE.json
new file mode 100644
index 0000000..5a3ee34
--- /dev/null
+++ b/trans-datax-job/datax/job/3005.job_TMP_TB_ROLE.json
@@ -0,0 +1,88 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ROLEID,
+    ROLECATEGORYID,
+    ROLECODE,
+    ROLENAME,
+    ROLEMEMO,
+    ROLESTATUS,
+    ROLECREATEUSER,
+    ROLECREATETIME,
+    ROLEUPDATETIME,
+    ROLEAPPIDS,
+    ROLEISDELETED,
+    ROLEDELETETIME,
+    ROLEDELETEUSER
+FROM UIDS_TB_ROLE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ROLEID",
+                            "ROLECATEGORYID",
+                            "ROLECODE",
+                            "ROLENAME",
+                            "ROLEMEMO",
+                            "ROLESTATUS",
+                            "ROLECREATEUSER",
+                            "ROLECREATETIME",
+                            "ROLEUPDATETIME",
+                            "ROLEAPPIDS",
+                            "ROLEISDELETED",
+                            "ROLEDELETETIME",
+                            "ROLEDELETEUSER"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_ROLE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_ROLE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3006.job_TMP_TB_APPLICATION.json b/trans-datax-job/datax/job/3006.job_TMP_TB_APPLICATION.json
new file mode 100644
index 0000000..5bc685e
--- /dev/null
+++ b/trans-datax-job/datax/job/3006.job_TMP_TB_APPLICATION.json
@@ -0,0 +1,92 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT APPID,
+    APPCODE,
+    APPNAME,
+    APPMEMO,
+    APPSTATUS,
+    APPCREATEUSER,
+    APPCREATETIME,
+    APPUPDATETIME,
+    APPURI,
+    APPICON,
+    APPSEQUENCE,
+    APPDISPLAY,
+    APPISDELETED,
+    APPDELETETIME,
+    APPDELETEUSER
+FROM UIDS_TB_APPLICATION
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "APPID",
+                            "APPCODE",
+                            "APPNAME",
+                            "APPMEMO",
+                            "APPSTATUS",
+                            "APPCREATEUSER",
+                            "APPCREATETIME",
+                            "APPUPDATETIME",
+                            "APPURI",
+                            "APPICON",
+                            "APPSEQUENCE",
+                            "APPDISPLAY",
+                            "APPISDELETED",
+                            "APPDELETETIME",
+                            "APPDELETEUSER"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_APPLICATION"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_APPLICATION"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3007.job_TMP_TB_FUNCTION.json b/trans-datax-job/datax/job/3007.job_TMP_TB_FUNCTION.json
new file mode 100644
index 0000000..5157242
--- /dev/null
+++ b/trans-datax-job/datax/job/3007.job_TMP_TB_FUNCTION.json
@@ -0,0 +1,96 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT FUNCID,
+    FUNCAPPID,
+    FUNCPARENTID,
+    FUNCCODE,
+    FUNCNAME,
+    FUNCMEMO,
+    FUNCSTATUS,
+    FUNCCREATEUSER,
+    FUNCCREATETIME,
+    FUNCUPDATETIME,
+    FUNCURI,
+    FUNCURIPATTERN,
+    FUNCATTRIBUTE,
+    FUNCSEQUENCE,
+    FUNCISDELETED,
+    FUNCDELETETIME,
+    FUNCDELETEUSER
+FROM UIDS_TB_FUNCTION
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "FUNCID",
+                            "FUNCAPPID",
+                            "FUNCPARENTID",
+                            "FUNCCODE",
+                            "FUNCNAME",
+                            "FUNCMEMO",
+                            "FUNCSTATUS",
+                            "FUNCCREATEUSER",
+                            "FUNCCREATETIME",
+                            "FUNCUPDATETIME",
+                            "FUNCURI",
+                            "FUNCURIPATTERN",
+                            "FUNCATTRIBUTE",
+                            "FUNCSEQUENCE",
+                            "FUNCISDELETED",
+                            "FUNCDELETETIME",
+                            "FUNCDELETEUSER"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_FUNCTION"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_FUNCTION"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3008.job_TMP_TB_RIGHT.json b/trans-datax-job/datax/job/3008.job_TMP_TB_RIGHT.json
new file mode 100644
index 0000000..561d154
--- /dev/null
+++ b/trans-datax-job/datax/job/3008.job_TMP_TB_RIGHT.json
@@ -0,0 +1,90 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT RIGHTID,
+    RIGHTFUNCID,
+    RIGHTAPPID,
+    RIGHTCODE,
+    RIGHTNAME,
+    RIGHTMEMO,
+    RIGHTSTATUS,
+    RIGHTCREATEUSER,
+    RIGHTCREATETIME,
+    RIGHTUPDATETIME,
+    RIGHTATTRIBUTE,
+    RIGHTISDELETED,
+    RIGHTDELETETIME,
+    RIGHTDELETEUSER
+FROM UIDS_TB_RIGHT
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "RIGHTID",
+                            "RIGHTFUNCID",
+                            "RIGHTAPPID",
+                            "RIGHTCODE",
+                            "RIGHTNAME",
+                            "RIGHTMEMO",
+                            "RIGHTSTATUS",
+                            "RIGHTCREATEUSER",
+                            "RIGHTCREATETIME",
+                            "RIGHTUPDATETIME",
+                            "RIGHTATTRIBUTE",
+                            "RIGHTISDELETED",
+                            "RIGHTDELETETIME",
+                            "RIGHTDELETEUSER"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_RIGHT"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_RIGHT"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3011.job_TMP_TB_ACCOUNTSECURITYEMAIL.json b/trans-datax-job/datax/job/3011.job_TMP_TB_ACCOUNTSECURITYEMAIL.json
new file mode 100644
index 0000000..e118c1b
--- /dev/null
+++ b/trans-datax-job/datax/job/3011.job_TMP_TB_ACCOUNTSECURITYEMAIL.json
@@ -0,0 +1,80 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT EMAILID,
+    EMAILACCOUNTID,
+    EMAILINFO,
+    EMAILSECURITY,
+    EMAILCODE,
+    EMAILSTATUS,
+    EMAILCREATEUSER,
+    EMAILCREATETIME,
+    EMAILUPDATETIME
+FROM UIDS_TB_ACCOUNTSECURITYEMAIL
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "EMAILID",
+                            "EMAILACCOUNTID",
+                            "EMAILINFO",
+                            "EMAILSECURITY",
+                            "EMAILCODE",
+                            "EMAILSTATUS",
+                            "EMAILCREATEUSER",
+                            "EMAILCREATETIME",
+                            "EMAILUPDATETIME"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_ACCOUNTSECURITYEMAIL"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_ACCOUNTSECURITYEMAIL"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/3012.job_TMP_TB_ACCOUNTSECURITYMOBILE.json b/trans-datax-job/datax/job/3012.job_TMP_TB_ACCOUNTSECURITYMOBILE.json
new file mode 100644
index 0000000..b80e81e
--- /dev/null
+++ b/trans-datax-job/datax/job/3012.job_TMP_TB_ACCOUNTSECURITYMOBILE.json
@@ -0,0 +1,80 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT MOBILEID,
+    MOBILEACCOUNTID,
+    MOBILEINFO,
+    MOBILESECURITY,
+    MOBILECODE,
+    MOBILESTATUS,
+    MOBILECREATEUSER,
+    MOBILECREATETIME,
+    MOBILEUPDATETIME
+FROM UIDS_TB_ACCOUNTSECURITYMOBILE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "MOBILEID",
+                            "MOBILEACCOUNTID",
+                            "MOBILEINFO",
+                            "MOBILESECURITY",
+                            "MOBILECODE",
+                            "MOBILESTATUS",
+                            "MOBILECREATEUSER",
+                            "MOBILECREATETIME",
+                            "MOBILEUPDATETIME"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_TB_ACCOUNTSECURITYMOBILE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_TB_ACCOUNTSECURITYMOBILE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4001.job_TMP_REF_ORGANIZEUSER.json b/trans-datax-job/datax/job/4001.job_TMP_REF_ORGANIZEUSER.json
new file mode 100644
index 0000000..262a36b
--- /dev/null
+++ b/trans-datax-job/datax/job/4001.job_TMP_REF_ORGANIZEUSER.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ORGID,
+    USERID
+FROM UIDS_REF_ORGANIZEUSER
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ORGID",
+                            "USERID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_ORGANIZEUSER"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_ORGANIZEUSER"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4002.job_TMP_REF_USERGROUPACCOUNT.json b/trans-datax-job/datax/job/4002.job_TMP_REF_USERGROUPACCOUNT.json
new file mode 100644
index 0000000..dcc7fbb
--- /dev/null
+++ b/trans-datax-job/datax/job/4002.job_TMP_REF_USERGROUPACCOUNT.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 100,
+                "percentage": 1.0
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT USERGRPID,
+    ACCOUNTID
+FROM UIDS_REF_USERGROUPACCOUNT
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "USERGRPID",
+                            "ACCOUNTID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_USERGROUPACCOUNT"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_USERGROUPACCOUNT"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4003.job_TMP_REF_ACCOUNTROLE.json b/trans-datax-job/datax/job/4003.job_TMP_REF_ACCOUNTROLE.json
new file mode 100644
index 0000000..f778b66
--- /dev/null
+++ b/trans-datax-job/datax/job/4003.job_TMP_REF_ACCOUNTROLE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT ACCOUNTID,
+    ROLEID
+FROM UIDS_REF_ACCOUNTROLE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "ACCOUNTID",
+                            "ROLEID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_ACCOUNTROLE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_ACCOUNTROLE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4004.job_TMP_REF_USERGROUPROLE.json b/trans-datax-job/datax/job/4004.job_TMP_REF_USERGROUPROLE.json
new file mode 100644
index 0000000..1e032b4
--- /dev/null
+++ b/trans-datax-job/datax/job/4004.job_TMP_REF_USERGROUPROLE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT USERGRPID,
+    ROLEID
+FROM UIDS_REF_USERGROUPROLE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "USERGRPID",
+                            "ROLEID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_USERGROUPROLE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_USERGROUPROLE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4005.job_TMP_REF_USERROLE.json b/trans-datax-job/datax/job/4005.job_TMP_REF_USERROLE.json
new file mode 100644
index 0000000..b6b74e7
--- /dev/null
+++ b/trans-datax-job/datax/job/4005.job_TMP_REF_USERROLE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT USERID,
+    ROLEID
+FROM UIDS_REF_USERROLE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "USERID",
+                            "ROLEID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_USERROLE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_USERROLE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4006.job_TMP_REF_APPLICATIONROLE.json b/trans-datax-job/datax/job/4006.job_TMP_REF_APPLICATIONROLE.json
new file mode 100644
index 0000000..7739d89
--- /dev/null
+++ b/trans-datax-job/datax/job/4006.job_TMP_REF_APPLICATIONROLE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT APPID,
+    ROLEID
+FROM UIDS_REF_APPLICATIONROLE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "APPID",
+                            "ROLEID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_APPLICATIONROLE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_APPLICATIONROLE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4007.job_TMP_REF_FUNCTIONROLE.json b/trans-datax-job/datax/job/4007.job_TMP_REF_FUNCTIONROLE.json
new file mode 100644
index 0000000..46951c0
--- /dev/null
+++ b/trans-datax-job/datax/job/4007.job_TMP_REF_FUNCTIONROLE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT FUNCID,
+    ROLEID
+FROM UIDS_REF_FUNCTIONROLE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "FUNCID",
+                            "ROLEID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_FUNCTIONROLE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_FUNCTIONROLE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}
diff --git a/trans-datax-job/datax/job/4008.job_TMP_REF_RIGHTROLE.json b/trans-datax-job/datax/job/4008.job_TMP_REF_RIGHTROLE.json
new file mode 100644
index 0000000..b16b8e8
--- /dev/null
+++ b/trans-datax-job/datax/job/4008.job_TMP_REF_RIGHTROLE.json
@@ -0,0 +1,66 @@
+{
+    "job": {
+        "setting": {
+            "speed": {
+                "channel": 3
+            },
+            "errorLimit": {
+                "record": 0,
+                "percentage": 0.02
+            }
+        },
+        "content": [
+            {
+                "reader": {
+                    "name": "oraclereader",
+                    "parameter": {
+                        "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+                        "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+                        "connection": [
+                            {
+                                "querySql": [
+                                    "
+SELECT RIGHTID,
+    ROLEID
+FROM UIDS_REF_RIGHTROLE
+"
+                                ],
+                                "jdbcUrl": [
+                                    "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+                                ]
+                            }
+                        ]
+                    }
+                },
+
+                "writer": {
+                    "name": "mysqlwriter8",
+                    "parameter": {
+                        "username": "${MYSQLWRITER8_TMP_USERNAME}",
+                        "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+                        "column": [
+                            "RIGHTID",
+                            "ROLEID"
+                        ],
+                        "session": [
+                            "set session sql_log_bin=0",
+                            "set session sql_mode='ANSI'"
+                        ],
+                        "preSql": [
+                            "delete from TMP_REF_RIGHTROLE"
+                        ],
+                        "connection": [
+                            {
+                                "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+                                "table": [
+                                    "TMP_REF_RIGHTROLE"
+                                ]
+                            }
+                        ]
+                    }
+                }
+
+            }
+        ]
+    }
+}