Re: Long columns obsolete

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Sat, 6 Dec 2003 13:51:01 -0600
Message-ID: <ApqAb.1134$IF.550@bignews4.bellsouth.net>

I wish Oracle would either expand varchar2 or provide another datatype SOMEWHERE (just 32K would be ok) between 4GIG and 4K :)

Dealing with CLOBs appears to be a fair amount of "work" as opposed to varchar2 .

Does anyone know if Oracle Applications use CLOBs?

When Oracle starts using these things in their own applications, then I would think they are really ready for primetime usage... like when they starting using CBO with 8i if I remember correctly.

Of course, the data dictionary may never change, but you would think their applications would .

-- 
"Robert" <cookie - remove - @tref.nl> wrote in message
news:bqs78c$lh1$1_at_reader10.wxs.nl...


> Hi there,

>

>

> I have a third party application which uses a lot of LONG columns.

> I heard Oracle has them for backwards compatibility and from 9i they are

> obsolete.

>

> Is this true ? I can't seems to find a statement on this at the oracle

site


>

> If you had the choice would you use LONG's ?

>

>

>

>

> Cheers,

>

> Robert

>

Received on Sat Dec 06 2003 - 13:51:01 CST