Creating or altering BLOB/CLOB column length - Oracle 11

Question

I have a varchar2 column and I want to store data bigger than 4k of length. So I created a new column BLOB. But, I saw that the length is also 4k by default.

How can I make it bigger than 4k? Thanks in advance.

Answer 1

DBeaver is probably misinterpreting ALL_TAB_COLUMNS.DATA_LENGTH and showing incorrect information. As others have pointed out, BLOBs and CLOBs can store many gigabytes of data.

For most columns, DATA_LENGTH shows important information about the maximum size of data. But for BLOBs and CLOBs, DATA_LENGTH only indicates how much data could be stored within the row, which doesn't matter to users 99.99% of the time. See this answer for a more thorough explanation of what the exact number means.