oracle datatype

Question

Is there any data type greater than CLOB in oracle

Answer 1

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.

Answer 2

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

Answer 3

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.