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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close