datax oracle2oracle oracle导入oracle
oracle2oracle.json
注意事项:
1、reader过程url有[],writer过程没有[]
2、在执行之前writer过程的表已经创建好
3、严格按照格式书写
4、注意主机名、数据库名、用户名、密码不要写错
对人工智能感兴趣的同学,可以点击以下链接:
现在人工智能非常火爆,很多朋友都想学,但是一般的教程都是为博硕生准备的,太难看懂了。最近发现了一个非常适合小白入门的教程,不仅通俗易懂而且还很风趣幽默。所以忍不住分享一下给大家。点这里可以跳转到教程。
https://www.cbedai.net/u014646662
{
"job": {
"content": [
{
"reader": {
"name": "oraclereader",
"parameter": {
"column": ["WIP_ENTITY_ID","ORGANIZATION_ID","LAST_UPDATE_DATE"],
"connection": [
{
"jdbcUrl": ["jdbc:oracle:thin:@hostname1:1521:orcl"],
"table": ["wip_entities"]
}
],
"password": "password",
"username": "username",
"where":"rownum < 1000"
}
},
"writer": {
"name": "oraclewriter",
"parameter": {
"column": ["WIP_ENTITY_ID","ORGANIZATION_ID","LAST_UPDATE_DATE"],
"connection": [
{
"jdbcUrl": "jdbc:oracle:thin:@hostname2:1521:orcl",
"table": ["wip_entities"]
}
],
"password": "password",
"username": "username",
"preSql":["truncate table wip_entities"]
}
}
}
],
"setting": {
"speed": {
"channel": 6
}
}
}
}
DataX3.0安装过程:https://blog.csdn.net/u014646662/article/details/82748055
DataX3.0 Oracle导入Oracle:https://blog.csdn.net/u014646662/article/details/82777966
DataX3.0 MySQL导入MySQL:https://blog.csdn.net/u014646662/article/details/82778067
DataX3.0源离线同步工具介绍: https://blog.csdn.net/u014646662/article/details/82792725