Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MichaelWee
Contributor
Contributor

Replicate - Oracle Clob to SQL Server

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!

Labels (1)
2 Replies
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
MichaelWee
Contributor
Contributor
Author

Thank you.   Any observations on Incremental load?