What is the largest row size that I can create in a table? How many columns or bytes can it contain?
asked
Create table limits
In general, this is answered by the "Database Limits" section of the Reference Manual (Appendix A in 10g and 11g, Section 4 in 8i and 9i).
It would help to understand the distinction between in line storage and out of line storage for LOBs. LOBs stored "in line" are stored alongside the row data, "out of line" are stored in a separate segment, and a pointer to that data is stored in the row.
The largest amount of data that could be possibly be stored for a single row would be 1000 columns of LOBs in a database 32k block size, at (2^32 - 1) * (2^15) ~= 128 TB per field, or 125 PB (petabytes) per row.
The largest with in-line storage would be 1000 columns of 4000 byte VARCHARs at just under 4MB per row. (Or if you prefer IEC units, that's exactly 4MB, and the previous result was 125PiB, but "pebibytes" just sounds odd.)
