Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have to move Oracle tables to SQL Server. Any Oracle table with a column with CLOB data type, Takes up to 15 + hours for a full load. Any suggestions? I tried enabling LOB columns with different sizes and unlimited sizes. Does anyone have some insight on how to improve performance? Thanks!
Hello @MichaelWee ,
If you are meaning a single table full load takes up too long time then you can use Parallel Load to accelerate the replication of large tables by splitting the table into multiple segments and loading the segments in parallel.
Also please check the Handling LOB columns , hope this helps.
Regards,
John.
Thank you. Any observations on Incremental load?