Maximum character data that a CLOB and NCLOB type can store
Quote from the documentation
The LOB data types for character data are CLOB and NCLOB. They can store up to 8 terabytes of character data (CLOB) or national character set data (NCLOB).
and this is another quote from the same page:
The CLOB and NCLOB data types store up to 128 terabytes of character data in the database. CLOBs store database database character set data, and NCLOBs store national Unicode character set data. `
I'm a little confused, is there some misunderstanding in the documentation or am I missing something?
source to share
The difference is that you can define LOBs with different "chunk" sizes. Plus their maximum size is limited by the number of used database blocks. If you are creating a database (or tablespace) with a large block size, this means that the LOB can contain more data.
(4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage)
CLOBs can store up to character data
And the following sentence describes the relationship to block size:
If the tablespaces in your database are standard block size and if you used the CHUNK value for the LOB store when creating the LOB column, this is equivalent
(4 gigabytes - 1) * (database block size)
.
source to share