Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    SOLVED Oracle to Mysql 大表初始化需要Order by 导致temp tablespace 满,失败

    问答区
    oracle 迁移 ,全量同步,order by
    2
    2
    29
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • 刘德鹏
      刘德鹏 last edited by

      Oracle to Mysql 场景,Oracle的大表初始化同步需要进行Order by 导致temp tablespace 满,导数失败。是否可以关闭order by。

      1 Reply Last reply Reply Quote 0
      • zycgit
        zycgit last edited by

        不可以的,建议把大表分到单独同步任务来处理。或者调大 temp tablespace。

        CloudCanal 全量同步方式是:根据 PK 分页方式方式选择数据同步到对端,同步期间任务可以暂停。

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post
        Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2