CLOB and VARCHAR2

pts.
Tags:
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)?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Abhivyakti
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/clob-and-varchar2/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following