Re: 2 LONGS in 1 TABLE

In article <1995Jun19.215525.24485_at_wmdhh.wmd.de>,

   rose_at_wmdhh.wmd.de (Axel Rose) wrote:
>Hi Netters,
>
>Current available versions of Oracle (7.1) do not support more than
>a single long column per table
 

>1.
>What workarounds do you use?

It is sometimes a problem. I actually find I have more problems with Oracle not being able to create a table from a "select" with a long column.

Actually, In our environment whenever I have a column that will end up being signifigantly larger than the rest of the columns combined (varchar2 (2000) or long) I move the offending column into a separate table. This saves time and prevents oracle from scanning through all that data when searching the table.

>2.
>Are views a usable solution?

Nope. Oracle is far too clever to let you slip that one by it.

cheers,

John Kline | .sig under construction jtkline_at_icon-stl.net | Received on Wed Jun 21 1995 - 00:00:00 CEST