Re: 2 LONGS in 1 TABLE

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
>create table longy( n number, l1 long, l2 long);
>ORA-001754 .. only one long per table ..
 

>1.
>What workarounds do you use?

My favorite to to create a table just for longs.

 key			whatever
 long_type		char(20)
 long_length    number
 long_value     long

This has the advantage of a single table to defrag.

>2.
>Are views a usable solution?
>create table longy1( n1 number, l1 long);
>create table longy2( n2 number, l2 long);
>create view v_longy( n, l1, l2 ) as
>(select n1, l1, l2 from longy1, longy2 where n1 = n2);

Sorry. You run into the 1 long per table limit in the temp table.

>3.
>Is Oracle planning a solution for future versions?

Beats me.

>4.
>varchar2 greater than 2000 chars would be a solution too.
>Is this urgently needed extension scheduled at Oracle ??

Ask Oracle. I haven't a clue

>Thanks for any opinnion or hint, Axel

>--
>Axel Rose - Hamburg, Germany "Ich bin der Geist, der stets verneint!
>e-mail: rose_at_wmdhh.wmd.de Und das mit Recht; denn alles, was entsteht,
>phone : +49-40-58958-236 Ist wert, dass es zugrunde geht;
>fax : +49-40-58958-199 Drum besser waer's, dass nichts entstuende."

--
J Faylore       These are the times which try Men's souls.
                Tyranny, like Hell, is not easily conquered.
                  --  Thomas Paine