A XML message length is 80000 now, I want to save it to the oracle, the original use of the CLob remaining, now want to change the form of varchar2, XML message length after GZIP compression is still in about 10000 6, what good method to solve it is compressed packet in segmentation or have other method? Thanks!
By the way, clob storage value is how much of how many, or a fixed size, no matter how small, you save size are like that

CodePudding user response:

Lob accounts for how much how much,


The situation, you want to points to a varchar field storage, 4000 a, 10, 40000, when using,

CodePudding user response:

Why do you want to split into varchar2, clob is itself in order to handle large text

CodePudding user response:

To save the compressed XML in external files, database only relative path to the file name, should be more convenient and post-processing,

CodePudding user response:

The building Lord why will clob into varchar2? Also has a great god mentioned above, the latter only support 4 k length,
Clob is a variable-length, accounts for how much how much, support data maximum (4 gigabytes - 1) * (the database block size),