Upgrade to Oracle 8 and use Clobs. Longs are not going to be supported much
longer.
Jim
"Alejandro Nieto" <anieto1_at_lucent.com> wrote in message
news:3DB93D10.20402_at_lucent.com...
> Hi there,
>
> I'm newby in Oracle and I have a problem with a VARCHAR datatype filed
> in a table in ORACLE 7.
>
> The issue is I have a table which contains several columns or field
> with VARCHAR2(2000) datatype. Those fields due to implementation
> requirement needs to grow i mean we need to store about 2Mbytes in the
> value that represent the field. I was thinking to use the LONG datatype
> but unfortunately in Oracle 7 only one column in the table can be LONG
> and i have more than one field in the same table which need to store
> about 2Mbytes.
>
> The first idea came to my mind is in order to store the value of say my
> attribute i should use 10 columns or fields in the table and then use an
> algorithm to store and retrieve the data into/from those 10 fields. The
> performance in this case is not a big issue because it is for a simulator.
>
> Is there anybody can help me out with a better solution that this poor
one?
>
> Thanks a lot in advance for your help
> Alejandro
>
Received on Fri Oct 25 2002 - 09:34:35 CDT
