{
  "job": {
    "setting": {
      "speed": {
        "channel": 3,
        "byte": 1048576
      },
      "errorLimit": {
        "record": 0,
        "percentage": 0.02
      }
    },
    "content": [
      {
        "reader": {
          "name": "oraclereader",
          "parameter": {
            "username": "c##hbhe",
            "password": "wwwwww",
        "column": [{"index": "0","type": "TIMESTAMP"}],
            "splitPk": "",
            "connection": [
              {
                "querySql": [
                  "select t.*  from t1 t where 1=1 and t.update_time >= trunc(sysdate -1 ,'dd')  and t.update_time < trunc(sysdate ,'dd') "
                ],
                "jdbcUrl": [
                  "jdbc:oracle:thin:@192.168.56.100:1521:orcl"
                ]
              }
            ]
          }
        },
        "writer": {
          "name": "oraclewriter",
          "parameter": {
            "username": "hbhe",
            "password": "wwwwww",
            "column": ["*"],
            "preSql": [
              "delete from t1 t where  t.update_time >= trunc(sysdate -1 ,'dd')  and t.update_time < trunc(sysdate ,'dd')"
            ],
            "connection": [
              {
                "table": [
                  "t1"
                ],
                "jdbcUrl": "jdbc:oracle:thin:@//192.168.56.113:1521/orcl"
              }
            ]
          }
        }
      }
    ]
  }
}

执行命令执行同步
python /datax/bin/datax.py /datax/job/oracletooracle.jsonhttp://www.cndba.cn/hbhe0316/article/4750http://www.cndba.cn/hbhe0316/article/4750http://www.cndba.cn/hbhe0316/article/4750

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle