https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2426248#M9955 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280">@iti-attunity-sup</a>&nbsp;,</P> <P>Thanks for reaching out to Qlik Community!</P> <P>I guess I did not get the question very well, would you please elaborate what's the challenge about "<SPAN>SecureFiles LOB"?</SPAN></P> <P><SPAN>If you are talking about the regular LOB size limitation, yes, it's supported with prerequisites eg:</SPAN></P> <UL> <LI><A title="The maximum permitted value for this field is 102400 KB (100 MB)" href="https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/target_metadata.htm#ar_tasks_custom_1624443382_1693100:~:text=Limit%20LOB%20size,KB%20(100%20MB)." target="_blank" rel="noopener"><SPAN>The maximum permitted value for this field is 102400 KB (100 MB)</SPAN></A></LI> <LI><A title="LOB data types are supported only in tables with a primary key or unique index" href="https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/target_metadata.htm#ar_tasks_custom_1624443382_1693100:~:text=During%20CDC%20or%20during%20Full%20Load%20when%20the%20Allow%20unlimited%20LOB%20size%20option%20is%20enabled%2C%20LOB%20data%20types%20are%20supported%20only%20in%20tables%20with%20a%20primary%20key%20or%20unique%20index." target="_blank" rel="noopener"><SPAN>LOB data types are supported only in tables with a primary key or unique index</SPAN></A></LI> </UL> <P><SPAN>Hope this helps.</SPAN></P> <P><SPAN>John.</SPAN></P> Sun, 03 Mar 2024 08:53:44 GMT john_wang 2024-03-03T08:53:44Z https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2425608#M9900 <P>Hello, Support Team</P> <P>Source is Oracle.<BR />When source table use SecureFiles LOB,<BR />does Task setting：「Limit LOB size to (KB)」support?</P> <P>Best Regards.</P> Fri, 01 Mar 2024 01:53:34 GMT https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2425608#M9900 iti-attunity-sup 2024-03-01T01:53:34Z https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2426248#M9955 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280">@iti-attunity-sup</a>&nbsp;,</P> <P>Thanks for reaching out to Qlik Community!</P> <P>I guess I did not get the question very well, would you please elaborate what's the challenge about "<SPAN>SecureFiles LOB"?</SPAN></P> <P><SPAN>If you are talking about the regular LOB size limitation, yes, it's supported with prerequisites eg:</SPAN></P> <UL> <LI><A title="The maximum permitted value for this field is 102400 KB (100 MB)" href="https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/target_metadata.htm#ar_tasks_custom_1624443382_1693100:~:text=Limit%20LOB%20size,KB%20(100%20MB)." target="_blank" rel="noopener"><SPAN>The maximum permitted value for this field is 102400 KB (100 MB)</SPAN></A></LI> <LI><A title="LOB data types are supported only in tables with a primary key or unique index" href="https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/target_metadata.htm#ar_tasks_custom_1624443382_1693100:~:text=During%20CDC%20or%20during%20Full%20Load%20when%20the%20Allow%20unlimited%20LOB%20size%20option%20is%20enabled%2C%20LOB%20data%20types%20are%20supported%20only%20in%20tables%20with%20a%20primary%20key%20or%20unique%20index." target="_blank" rel="noopener"><SPAN>LOB data types are supported only in tables with a primary key or unique index</SPAN></A></LI> </UL> <P><SPAN>Hope this helps.</SPAN></P> <P><SPAN>John.</SPAN></P> Sun, 03 Mar 2024 08:53:44 GMT https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2426248#M9955 john_wang 2024-03-03T08:53:44Z https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2426312#M9962 <P>Hello John-san.</P> <P>Thank you for your reply.</P> <P>Oracle LOB storage has two types, SecureFiles LOB and BasicFiles LOB.<BR />If Source table LOB column select "SecureFiles LOB", Is there any problem with using "Limit LOB size to (KB)" ?</P> <P>Best, Regards.</P> Mon, 04 Mar 2024 01:05:47 GMT https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2426312#M9962 iti-attunity-sup 2024-03-04T01:05:47Z https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2426321#M9963 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280">@iti-attunity-sup</a>&nbsp;,</P> <P>Thanks for the clarification.</P> <P><A title="SecureFiles is the default storage mechanism for LOBs starting with Oracle Database 12c" href="https://docs.oracle.com/en/database/oracle/oracle-database/19/adlob/introduction-to-large-objects.html#GUID-67FBC558-69AC-4BCC-80B5-F2961283A4A8:~:text=STORE%20AS%20LOB%20...-,1.10%20BasicFiles%20and%20SecureFiles%20LOBs,rather%20then%20BasicFiles.%20BasicFiles%20will%20be%20deprecated%20in%20a%20future%20release.,-See%20Also%3A" target="_blank" rel="noopener">SecureFiles is the default storage mechanism for LOBs starting with Oracle Database 12c</A>, Qlik Replicate supports it as well&nbsp;<SPAN>with using "Limit LOB size to (KB)".</SPAN></P> <P><SPAN>Regards,</SPAN></P> <P><SPAN>John.</SPAN></P> Mon, 04 Mar 2024 02:23:37 GMT https://community.qlik.com/t5/Qlik-Replicate/About-Limit-LOB-size-to-KB/m-p/2426321#M9963 john_wang 2024-03-04T02:23:37Z