Limit on CLOB datatype in Oracle 10g

In Oracle 10g, does the 32K limit on the CLOB datatype still apply?

Published: 14 May 2007

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

All
News
Get Started
Evaluate
Manage
Problem Solve

Have a question for an expert?

Please add a title for your question

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

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Managing unstructured data is crucial to enterprises' AI goals

Unstructured data makes up a huge portion of most businesses' data volume. But, with data-hungry AI systems coming online, making...

ScyllaDB set to improve NoSQL database performance

ScyllaDB has been helpful for big organizations such as Comcast, which was able to trim from nearly 1,000 database nodes to 78 ...

Translytical data platforms provide options to unify databases

Forrester identifies top vendors in the translytical database category and common elements that help make the unified database ...

SearchBusinessAnalytics

Yellowfin 9 marked by developer tools, revamped mobile app

The latest product update from BI vendor Yellowfin features new dashboard design tools, a revamped mobile app and a repackaged ...

Evolution of analytics marked by wider dissemination of data

With BI platforms getting easier to use by the year and enabling more self-service users in process, the value of analytics is ...

Analytics revolution has spread the wealth of information

Business intelligence over the last 20 years has been marked by the opening up of data to everyday business users after it was ...

SearchSAP

SMBs focus on future with S/4HANA and SAP intelligent enterprise

Medical device startup Enable Injections is small now but intends to be big soon, so it's implementing SAP S/4HANA in phases to ...

A primer on Employee Central Service Center

SAP has created Employee Central Service Center to simplify how HR issues get resolved. Here's a look at who it's for, how it ...

SAP sees S/4HANA migration as its future, but do customers?

SAP S/4HANA is seen as an ideal platform for companies to build the intelligent enterprise, but SAP still faces problems getting ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

Why AI application development isn't as far away as you think

The distance between application development and AI development continues to narrow. Here's how to integrate AI into your app dev...

AWS ups Java support, joins Java Community Process

By joining the Java Community Process, AWS will have its say over how the Java language and platform will evolve to meet the ...

AWS gets behind Rust programming language

AWS has joined Microsoft, Google, Mozilla and other major vendors in using and supporting the Rust programming language as a ...

SearchDataCenter

Top 5 options for Linux certifications

Are you ready to expand your Linux knowledge? Here's a look at the latest courses, training content and exams available from ...

New hardware, use cases shape server benchmarking needs

Advancements in server hardware help admins address the latest data-intensive use cases. But this brings questions about the ...

Top guidelines for edge computing software selection

Finding edge software that meets all your organization's needs requires help from both the business and IT sides. Get the right ...

SearchContentManagement

OpenText's Carbonite acquisition expands its cloud portfolio

OpenText acquires Carbonite, a vendor in cloud-based data protection and backup, disaster recovery and end-point security.

Employee engagement necessary for digital transformation projects

With four generations of employees in the workplace and confusion about projects, technology adoption efforts can fall flat. ...

Salesforce CMS: Users can publish without leaving platform

Catering to small and midsize customers, Salesforce remixes and upgrades existing features to form a content management system ...

SearchHRSoftware

ADP DataCloud makes its data easier to use

ADP DataCloud has an upgrade that includes what it calls 'mashup' capabilities. This will make it easier for customers to overlay...

HR mobile apps for employees strengthen HCM strategies

HR mobility management applications play a key role in recruiting, onboarding, talent management, engagements and, ultimately, ...

Impact of HR automation shows up in data and surveys

Recruiters are taking on more strategic roles, thanks in part to automation tools. But HR departments are facing another trend: ...

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.