Re: Max Size of Datatype

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 19 Sep 2007 21:47:14 GMT
Message-ID: <CNgIi.3545$nO3.1849@edtnps90>

<amerar_at_iwc.net> wrote in message
news:1190237744.501586.138180_at_y42g2000hsy.googlegroups.com...
>
> Hi All,
>
> We are currently on Oracle 8i, but in about 2 months we are moving to
> 10g.
>
> Anyhow, we need to store more than 4000 bytes in a certain column.
> How can I do that in 8i, such that it will not create a problem when
> moving it to 10g? Additionally, I do not want to break anything that
> currently uses the column I need to alter.....
>
> Thanks in advance.

The only way is to start using a BLOB. And that will break your applications.

Terry Dykstra Received on Wed Sep 19 2007 - 16:47:14 CDT