datax oracle2oracle oracle导入oracle

青旅半醒 2022-05-11 03:54 169阅读 0赞

# datax oracle2oracle oracle导入oracle #

oracle2oracle.json

注意事项：

1、reader过程url有\[\]，writer过程没有\[\]

2、在执行之前writer过程的表已经创建好

3、严格按照格式书写

4、注意主机名、数据库名、用户名、密码不要写错

对人工智能感兴趣的同学，可以点击以下链接：

[现在人工智能非常火爆，很多朋友都想学，但是一般的教程都是为博硕生准备的，太难看懂了。最近发现了一个非常适合小白入门的教程，不仅通俗易懂而且还很风趣幽默。所以忍不住分享一下给大家。点这里可以跳转到教程。][Link 1]

[https://www.cbedai.net/u014646662][Link 1]

{
        "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][https_blog.csdn.net_u014646662_article_details_82748055]

DataX3.0 Oracle导入Oracle：[https://blog.csdn.net/u014646662/article/details/82777966][https_blog.csdn.net_u014646662_article_details_82777966]

DataX3.0 MySQL导入MySQL：[https://blog.csdn.net/u014646662/article/details/82778067][https_blog.csdn.net_u014646662_article_details_82778067]

DataX3.0源离线同步工具介绍: [https://blog.csdn.net/u014646662/article/details/82792725][https_blog.csdn.net_u014646662_article_details_82792725]

[Link 1]: https://www.cbedai.net/u014646662
[https_blog.csdn.net_u014646662_article_details_82748055]: https://blog.csdn.net/u014646662/article/details/82748055
[https_blog.csdn.net_u014646662_article_details_82777966]: https://blog.csdn.net/u014646662/article/details/82777966
[https_blog.csdn.net_u014646662_article_details_82778067]: https://blog.csdn.net/u014646662/article/details/82778067
[https_blog.csdn.net_u014646662_article_details_82792725]: https://blog.csdn.net/u014646662/article/details/82792725