Q
Problem solve Get help with specific problems with your technologies, process and projects.

Correct use of CLOB datatype

I have a database design where CLOB datatypes are being used in place of VARCHAR2 datatypes. The VARCHAR2 datatypes are not large. I believe this was done was to use ConText indexes for Web page searches. I need some ammunition regarding the use or incorrect use of CLOBs.

I have a database design where CLOB datatypes are being used in place of VARCHAR2 datatypes. The VARCHAR2 datatypes are not large (10 to 50 in length). One table has 27 CLOBs. I believe the reason this was done was to use ConText indexes for Web page searches. I need some ammunition regarding the use or incorrect use of CLOBs. Can you answer or point me to a resource?
I'm not sure that I understand what you are asking. Oracle can handle 27 CLOB columns in a table just fine. But if the character data is less than 4,000 characters, you may be implementing unnecessary overhead. The VARCHAR2 datatype is easier to use and manage.

In Oracle 10g, ConText is now called Oracle Text. Take a look at the documentation for Oracle Text.

If you look at Chapter 2, they give you a quick example of how to set up Oracle Text. In their example, they are using Oracle Text against a VARCHAR2 column. So you are not required to use the CLOB datatype.

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