Quote from documentation
从文档引用
The LOB datatypes for character data are CLOB and NCLOB. They can store up to 8 terabytes of character data (CLOB) or national character set data (NCLOB).
字符数据的LOB数据类型是CLOB和NCLOB。它们可以存储多达8TB的字符数据(CLOB)或国家字符集数据(NCLOB)。
and this is another quote from same page:
这是同一页面的另一个引用:
The CLOB and NCLOB datatypes store up to 128 terabytes of character data in the database. CLOBs store database character set data, and NCLOBs store Unicode national character set data.`
CLOB和NCLOB数据类型在数据库中存储多达128 TB的字符数据。 CLOB存储数据库字符集数据,而NCLOB存储Unicode国家字符集数据
I am little confused, there is some misunderstanding in documentation or i miss something?
我有点困惑,在文档中有一些误解或我想念一些东西?
1 个解决方案
#1
The difference stems from the fact that you can define LOBs with different "chunk" sizes. Plus their maximum size is limited by the number of database blocks used for them. If you create a database (or tablespace) with a larger blocksize this means a LOB can contain more data.
不同之处在于您可以定义具有不同“块”大小的LOB。另外,它们的最大大小受限于用于它们的数据库块的数量。如果使用较大的块大小创建数据库(或表空间),则意味着LOB可以包含更多数据。
从手册:
CLOB objects can store up to
(4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage)of character dataCLOB对象最多可以存储字符数据的(4千兆字节-1)*(LOB存储的CHUNK参数的值)
And the next sentence describes the relation to the blocksize:
下一句话描述了与块大小的关系:
If the tablespaces in your database are of standard block size, and if you have used the default value of the CHUNK parameter of LOB storage when creating a LOB column, then this is equivalent to
(4 gigabytes - 1) * (database block size).如果数据库中的表空间是标准块大小,并且在创建LOB列时使用了LOB存储的CHUNK参数的缺省值,那么这相当于(4千兆字节-1)*(数据库块大小) 。
#1
The difference stems from the fact that you can define LOBs with different "chunk" sizes. Plus their maximum size is limited by the number of database blocks used for them. If you create a database (or tablespace) with a larger blocksize this means a LOB can contain more data.
不同之处在于您可以定义具有不同“块”大小的LOB。另外,它们的最大大小受限于用于它们的数据库块的数量。如果使用较大的块大小创建数据库(或表空间),则意味着LOB可以包含更多数据。
从手册:
CLOB objects can store up to
(4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage)of character dataCLOB对象最多可以存储字符数据的(4千兆字节-1)*(LOB存储的CHUNK参数的值)
And the next sentence describes the relation to the blocksize:
下一句话描述了与块大小的关系:
If the tablespaces in your database are of standard block size, and if you have used the default value of the CHUNK parameter of LOB storage when creating a LOB column, then this is equivalent to
(4 gigabytes - 1) * (database block size).如果数据库中的表空间是标准块大小,并且在创建LOB列时使用了LOB存储的CHUNK参数的缺省值,那么这相当于(4千兆字节-1)*(数据库块大小) 。