Multiple LONG columns

[MJP]

Hi,
I have a table where I need to have columns with multiple LONG datatype. But owing to the limitation of not having more than one LONG column per table, is there a workaround to this without creating additonal tables?

I also knew that I can use LONG RAW but again that gives me only 2 columns. I have a requirement for more than that.

-Prasad.

[jmodic]

Switch to Oracle8 if you are not allready there and use CLOBs, BLOBs, or BFILEs instead. There is no way you could use more than one of LONG types in a table.

[MJP]

Thanks for the reply. It was helpful. Yes I am on Oracle 8i so I can use all of these.