In Oracle 10g, the CLOB datatype can store up to (4GB-1)*(the value of the CHUNK parameter). If the CHUNK parameter is not explicitly set, the CLOB datatype can store up to (4GB-1)*(database block size).
In Oracle 8i and 9i, the CLOB datatype is restricted to 4GB in size.
The above can all be verified in the SQL Reference manual under Datatypes. You can find these manuals at http://tahiti.oracle.com.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.