Q
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.

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close