Oracle allows two bytes for row numbers, so theoretically they could go as high
as 65535. However, given the minimum row length (11 bytes) and maximum database
block size (32K), the pratical limit on the number of rows in a block is in fact
only 2970.


-----Original Message-----


Is there any rule as to how many rows of a table can be stored in a single
oracle block (besides the size of row and size of block comparison)