why oracle allows only one LONG column per table?

Could anybody tell why oracle allows only one "LONG" datatype column per table.

How many long columns are allowed in a table in Oracle?

The absolute maximum number of columns in a table is 1000.

How many long columns are allowed in a table?

Only one Long column can be present in a table.

What is the max length of long in Oracle?

The LONG RAW datatype represents fixed-length, binary data or byte strings. The maximum length of a LONG RAW value is 2147483647 bytes (two gigabytes).

LONGs were stored inline with the table data, so Oracle probably limited it to one per table because of that (performance hit as you'd be scanning over a lot of blocks) whereas LOBs are stored inline for only the first few k then go into the LOB segment for the rest.

As LONGs are totally depreciated and a major pain in the butt to deal with, stay well away from them where possible.