About Limit LOB size to (KB)

[iti-attunity-sup]

Hello, Support Team

Source is Oracle.
When source table use SecureFiles LOB,
does Task setting：「Limit LOB size to (KB)」support?

Best Regards.

[john_wang]

Hello @iti-attunity-sup ,

Thanks for reaching out to Qlik Community!

I guess I did not get the question very well, would you please elaborate what's the challenge about "SecureFiles LOB"?

If you are talking about the regular LOB size limitation, yes, it's supported with prerequisites eg:

• The maximum permitted value for this field is 102400 KB (100 MB)
• LOB data types are supported only in tables with a primary key or unique index

Hope this helps.

John.

[iti-attunity-sup]

Hello John-san.

Thank you for your reply.

Oracle LOB storage has two types, SecureFiles LOB and BasicFiles LOB.
If Source table LOB column select "SecureFiles LOB", Is there any problem with using "Limit LOB size to (KB)" ?

Best, Regards.

[john_wang · Accepted solution]

Hello @iti-attunity-sup ,

Thanks for the clarification.

SecureFiles is the default storage mechanism for LOBs starting with Oracle Database 12c, Qlik Replicate supports it as well with using "Limit LOB size to (KB)".

Regards,

John.