Is there any data type greater than CLOB in oracle
+2
A:
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.
Brian
2010-02-10 11:52:37
Good point, database is not a file system. I can't imagine the added overhead of trying to create/update/delete such large amounts of data inside a DB!
David Mann
2010-02-19 14:42:01
A:
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.
klausbyskov
2010-02-10 11:54:10
+4
A:
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
Tony Andrews
2010-02-10 11:57:15
I look forward to the day people start complaining that 128TB is too small for the kinds of data we want to store in the database :)
Jeffrey Kemp
2010-02-11 03:02:20
I can understand BLOBs in GBs and TBs (video etc). The thought of 4GB+ of text is pretty mindblowing through.
Gary
2010-02-11 22:46:30