Problem solve
Get help with specific problems with your technologies, process and projects.
Limit on CLOB datatype in Oracle 10g
In Oracle 10g, does the 32K limit on the CLOB datatype still apply?
There was a 32K limit to the size of a CLOB datatype. We are currently on Oracle version 10.2.0.1.0. Does that 32K limit still apply? If not, is there a new limit?
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.
Start the conversation
0 comments