why oracle allows only one LONG column per table?

blob, database, oracle

Solution

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.

Problem

Original source