开发者

oracle datatype

开发者 https://www.devze.com 2022-12-20 05:13 出处：网络

Is there an开发者_运维问答y data type greater than CLOB in oracleNo, there is no bigger datatype for storage in the database.In Oracle 11G the limit has increased from 4GB to \"(4 GB - 1) * DB_BLOCK_S

相关专题：oracle oracle10g sql

Is there an开发者_运维问答y data type greater than CLOB in oracle

No, there is no bigger datatype for storage in the database. In Oracle 11G the limit has increased from 4GB to "(4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)" - see Oracle 11G Database Reference

Do you mean in terms of storage? Clob is 4 gig. Anything 'larger' (or even smaller for that matter) you should consider storing just the location/path to the resource on disk, not the resource itself.

A detailed read on LOB design decisions.

If by greater you mean able to store more data, the answer is no. The four large object data types BFILE, BLOB, CLOB, and NCLOB all store up to 4 GB of data.