Home > IT Answers > Database > CLOB and VARCHAR2
Abhivyakti
0 pts.
 CLOB and VARCHAR2
Database, DB2, Oracle
Hi Isn't there a mid way between using the VARCHAR2 and CLOB datatypes? I need to have a column that will contains upto 6000 characters so I can not use VARCHAR2 for this. And i don't want to use CLOB as it might bring in some other problems like space management (coz it can occupy upto 4gb). Please suggest what can be done? How is the space management happening in case of a CLOB column(based on each rows data)?

Software/Hardware used:
ASKED: September 14, 2006  6:10 AM
UPDATED: September 14, 2006  6:43 AM
RELATED QUESTIONS
Answer Wiki:
I would suggest you pose this question on the asktom site. Tom Kyte would be an excellent resource (from Oracle) to address this question. He was at the PHLOUG meeting last night and shared some excellent tips on 10g R1 & 2 of the database. http://asktom.oracle.com
Last Wiki Answer Submitted:  September 14, 2006  6:43 am  by  NickatMFG   0 pts.
All Answer Wiki Contributors:  NickatMFG   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _