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